Rotate data table by 180 deg.

  • Thread starter Thread starter Gedi
  • Start date Start date
G

Gedi

Hi,
How to rotate data table (matrix) by 180 deg.?
Kind of what Transpose function do just I need to do two
Transposes in the same direction, as to rotate picture by
180 deg.
For example to rotate table:
1 2 3 4
11 12 13 14
21 22 23 24

And get:
24 23 22 21
14 13 12 11
4 3 2 1

Of course it is possible to do by linking one cell to
other, but very long process for big matrix.
Thank you.
Gedi.
 
With your range called "myrng", select A1 of a new sheet,
enter this formula, and press <ctrl><shift><enter>:

=OFFSET(myrng,ROWS(myrng)-ROW(),COLUMNS(myrng)-COLUMN(),)

Now fill across and down.

HTH
Jason
Atlanta, GA
 
I worked on this for some time on Excel 2011 for Mac and would like to update this method for rotating a data table 180 degrees. The formula is more like what I have below, where "original_table_bottom_right" and "new_table_top_left" are self explanatory references to the bottom right cell of the original table or the top left cell of the new table which has been rotated 180 degrees, respectively.

You can define the names for these two cells or you can reference these two cells directly in the formula, but if you reference the cells directly in the formula they need to be absolutely referenced with the style "$A$1".

=OFFSET(original_table_bottom_right,ROW(new_table_top_left)-ROW(),COLUMN(new_table_top_left)-COLUMN())
 
Back
Top