Forum Discussion

Copper Contributor

Jul 26, 2020

How do I flip a data table 180 degrees?

I have a data table that I need to reverse the sequence of the rows so the bottom row becomes the top row. Can this be done without sorting on a specific column?

excel

2 Replies

TheAntony
Iron Contributor
Jul 26, 2020
SSILVER31 , Here are a couple of options : First using the new dynamic array tables and the second using power query. See attached...
ReverseTable.xlsx21 KB
ziaddali
Copper Contributor
Jul 26, 2020
No, you can't, but you can add a new column that contains (1,2,3,....) and then sort all data depending on it.