I have a spreadsheet witn 30 columns and 15 rows with data and want to flip
it so that the columns become the rows and vice versa.

Try using Excel's TRANSPOSE function. Look it up in Excel help. Remember to
enter the formula with the Control-Shift-Enter keys (Not just the enter key
by itself). You also have to select a range of cells for the answer.

Hope this helps.

Bill Horton

"Becca" wrote:

I have a spreadsheet witn 30 columns and 15 rows with data and want to flip
it so that the columns become the rows and vice versa.

Select your *entire* datalist, say A1 to AD15.

Right click in the selection and choose "Copy".

Now, right click in the top left cell of the *new* location (*no* overlap),
OR ... navigate to another sheet,
Then choose "Paste Special",
Click on "Transpose", then <OK,
And you're done!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Becca" wrote in message
...
I have a spreadsheet witn 30 columns and 15 rows with data and want to flip
it so that the columns become the rows and vice versa.

Copy the range of Data.

Select a cell that will not be overwritten well away from that range or insert a
new sheet.

EditPasteSpecialTransposeOKEsc


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 10:34:02 -0700, Becca
wrote:

I have a spreadsheet witn 30 columns and 15 rows with data and want to flip
it so that the columns become the rows and vice versa.