Rearrange data by using index function make it simple and easy.

[meraz]

I have data in these form

1.png

arrange automatically in these form

2.png


example.xlsx

Ignore heading I will arrange later.

I think index function will work. Please make it simple and easy.

[AliGW]

Administrative Note:

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