Flipping a table of 5 columns, 250 rows

I want to flip a 250 by 5 matrix so that the last row of values, row 250 columns 1:5 become the first row, for columns 1 :5 row 249 columns 1:5 become the 2nd row, for columns 1 :5 row 248 columns ...

excel

mathetes
Sep 23, 2021
nahda36

I think you were on the right track with this: I tried adding an ordered series 1 to 250 as a helper column but don't understand the large range of options in the sort drop down menu.

To illustrate the process, I created a small set of six rows, five columns, then added a helper column on the left.
Select (highlight) that full range (B3:G9)

Then on the Data toolbar I click on the Sort icon, seen here on the far right

And then in the Dialog box select my Column Z--the "helper column" as the Sort by column.
and set the Order to "Largest to Smallest"

and click OK
With this result:

mathetes

Silver Contributor

Sep 23, 2021

nahda36

I think you were on the right track with this: I tried adding an ordered series 1 to 250 as a helper column but don't understand the large range of options in the sort drop down menu.

To illustrate the process, I created a small set of six rows, five columns, then added a helper column on the left.

Select (highlight) that full range (B3:G9)

Then on the Data toolbar I click on the Sort icon, seen here on the far right

And then in the Dialog box select my Column Z--the "helper column" as the Sort by column.

and set the Order to "Largest to Smallest"

and click OK

With this result: