rotate rows and columns in a spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

juicymixx@mailinator.com - 28 Jun 2005 19:33 GMT

Hey,

I have a very large spreadsheet. I want to rotate all the data in it
90 degrees, as in, I want row 1 to become the 60th column, and row 2 to
be the 59th column, etc... all the way to the last row becoming the
first column...

Is there an easy way to do this?

Reply to this Message

Bernie Deitrick - 28 Jun 2005 20:03 GMT

Copy the range, pasespecial transpose values, then above the range put the numbers 1 to 60, then
sort the whole table horizontally based on that first row.

HTH,
Bernie
MS Excel MVP

> Hey,
>
[quoted text clipped - 4 lines]
>
> Is there an easy way to do this?

Reply to this Message

Michael - 28 Jun 2005 20:41 GMT

Hi Juicy. Use a helper column and fill from row 1 to 60 with
60,59,58....3,2,1 and then sort ascending to reverse your rows. Then select
the data, copy, select a blank worksheet, put the cursor in A1 and Edit,
Paste Special, Transpose. HTH

Signature

Sincerely, Michael Colvin

> Hey,
>
[quoted text clipped - 4 lines]
>
> Is there an easy way to do this?

Reply to this Message