I have data want to rearrange in specific way any function available in excel.

I got data in excel I want to to rearrange in specific way any function available in excel the way I want rearrange data automatically.

Data what I Have in excel.

Screenshot 1.png


Data what I want to rearrange.

Screenshot 2.png


excel data
record.xlsx

in G3

=INDEX($A$3:$A$11,(ROWS($1:1)-1)*3+1)

in H3

=INDEX($D$3:$D$11,(ROWS($1:1)-1)*3+1)

in I3

=INDEX($C$3:$C$11,(ROWS($1:1)-1)*3+2)

in J3

=INDEX($C$3:$C$11,ROWS($1:1)*3)

copy all down


In F16

=INDEX($B$15:$D$23,(ROWS($1:1)-1)*3+1,1)

you should now be able to complete the second table.

Thank you very for much for helping, its worked for me. But I want to know why use *3 after rows function.
In F16 its fine after that result is wrong.

*3 because each set of data is 3 rows: use "Formulas">>>"Evaluate Formula" to see how the INDEX works

Administrative Note:

YOU HAVE ALREADY BEEN WARNED ABOUT THIS!

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...matically.html