Conversion of table into list

[Bizman007]

Hi

I want to rearrange data from table to a list form as given in the attached sheet. I will be thankful for any help

[canapone]

Hi,

in A12 and down

=IF(ROW(A1)<=COUNTA($B$3:$E$6),INDEX($A$3:$A$6,MOD(ROW(A1)-1,4)+1),"")

in B12

=IF(A12<>"",INDEX($B$3:$E$6,MATCH(A12,$A$3:$A$6,0),COUNTIF($A$12:A12,A12)),"")

Hope it helps

[canapone]

Hi,

see the attached file.

If you have to deal with many numbers, a pivot table could be helpful to do the trick.


Cheers