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.