Please help to convert data from one form to another

[himanshu123]

help me to converrt htis data from one form to another

 

[pecoflyer]

Please post a sample sheet so we can work with it; Pictures are nice to look at but useless

 

[himanshu123]

Sure!!

 

[bosco_yip]

Try...………...

1] In K2, copied down :

=IFERROR(INDEX(A$2:A$4,INT((ROW(A1)-1)/COUNTIF($A$1:$F$1,"Name"))+1),"")

2] In J2, copied down :

=IF($K2="","",VLOOKUP($K2,$A$1:$F$4,(COUNTIF($K$2:$K2,$K2)-1)*2+3,0))

3] In L2, copied down :

=IF($K2="","",VLOOKUP($K2,$A$1:$F$4,(COUNTIF($K$2:$K2,$K2)-1)*2+4,0))

 

[himanshu123]

i need a trick that can be automated on large data