Joined

·
378 Posts

I have an urgent problem: I have these datas:

Each list is different and doesn't have all the letter symbols and not in the same order.

01_f

BC 12 70.59%

BI 2 11.76%

X 2 11.76%

D 1 5.88%

Total 17

01_m

BC 24 96.00%

D 1 4.00%

Total 25

02_f

BC 8 50.00%

D 3 18.75%

X 3 18.75%

AC 1 6.25%

AN 1 6.25%

Total 16

etc...

(there are hundreds of lists like that all differents)

then I have this list of letter symbols that I have to fill in, the full list:

BC

AC

CC

BI

LI

FI

AN

AA

X

U

D

T

I need, for each list, to look for the % in front of one letter symbol and put it in front of the same letter symbol in the full list.

For example, from list one I need to take the % in front of BC (70.59%) and copy it in front of BC in the full list.

Then do it again with BI, X etc. Then do it again with the next lists...

to have the following table (imagine that _____ are empty cells):

BC_____70.59%______96.00% 50.00% 60.00%

AC_____ _____ _____ _____6.25% 4.00%

CC______ _____ _____ _____ _____ _____

BI _____11.76%______ _____ _____ _____

LI ______ _____ _____ _____ _____ _____

FI ______ _____ _____ _____ _____ 4.00%

AN______ _____ _____ _____ 6.25% _____

AA______ _____ _____ _____ _____ _____

X ______11.76%_____ _____18.75% 12.00%

U ______ _____ _____ _____ _____ _____

D _______5.88% 4.00% ______18.75% 20.00%

Is there any formula to do this?