I have a simple spreadsheet, one set of rows and columns. I would like to
re-organize it so the rows become the columns and the columns become the
rows. Is this possible?

Maybe -- if you have enough room.

If your data has 56,789 rows, then there won't be enough columns in any version
of excel to transpose the rows into columns.

But assuming that you do.
Create a new worksheet
Select the range on the old worksheet
Edit|Copy (in xl2003 menus)
Select A1 on that new sheet
Edit|Paste special|Check Transpose and click ok



On 07/30/2010 14:12, LAS wrote:
> I have a simple spreadsheet, one set of rows and columns. I would like to
> re-organize it so the rows become the columns and the columns become the
> rows. Is this possible?
>
>

--
Dave Peterson

Perfect!! Thanks!
"Dave Peterson" <(E-Mail Removed)> wrote in message
news:i2vi9l$46h$(E-Mail Removed)...
> Maybe -- if you have enough room.
>
> If your data has 56,789 rows, then there won't be enough columns in any
> version of excel to transpose the rows into columns.
>
> But assuming that you do.
> Create a new worksheet
> Select the range on the old worksheet
> Edit|Copy (in xl2003 menus)
> Select A1 on that new sheet
> Edit|Paste special|Check Transpose and click ok
>
>
>
> On 07/30/2010 14:12, LAS wrote:
>> I have a simple spreadsheet, one set of rows and columns. I would like
>> to
>> re-organize it so the rows become the columns and the columns become the
>> rows. Is this possible?
>>
>>
>
> --
> Dave Peterson