How To Flip and Reverse The Data

[Kenshin]

Hi meet you again in amazing forum, i have my question in my file attach

tq

 

[r2c2]

@Kenshin

Interesting question. Assuming your raw data is named data
You can use below formula

=IFERROR(INDEX(data, 6-ROWS($A$1:$A1),COUNTA(INDEX(data, 6-ROWS($A$1:$A1),))-COLUMNS($A$1:A$1)+1),"")

Change 6 to number of rows in your data + 1 (or use formula like counta)

Update: Just ignore the 0s or change them to blanks on display using format code 0;0;;

 

[bosco_yip]

Maybe,

In A8 copy across and down :

=IFERROR(INDEX($A$1:$E$5,6-ROWS($1:1),7-COLUMNS($A:A)-ROWS($1:1)),"")

Regards

 

[Kenshin]

Hi r2c2 and Bosco thank you man for awesome formula, thanks again

 

[Kenshin]

I have another request for another lay out table result, i try modify you formula but the end is fail

 

[Hui]

A8:
=OFFSET(A$6,-ROWS($A$8:A8),0)
Copy across and down
Then apply a custom number format of #;;;

 

[bosco_yip]

I have another request for another lay out table result, i try modify you formula but the end is fail

In A8, copy across and down :

=IFERROR(1/(1/INDEX(A$1:A$5,6-ROWS($1:1))),"")

Regards

 

[Kenshin]

Cool guys you're the man, thanks you again for the trick


cheers
Kenshin