Transposing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deena - 27 Oct 2006 17:05 GMT

I have a spreadsheet that contains 45 rows and 90 columns. I need to make the
rows into 45 columns and the columns into 90 rows.

Reply to this Message

shail - 27 Oct 2006 17:10 GMT

Hi Deena

Copy and right click your mouse button to select paste special and
select "Transpose".

thanks,

Shail

> I have a spreadsheet that contains 45 rows and 90 columns. I need to make the
> rows into 45 columns and the columns into 90 rows.

Reply to this Message

Anne Troy - 27 Oct 2006 17:13 GMT

From the help file....

Move data between rows and columns
Copy the data in one or more columns or rows.
Before you paste the copied data, right-click your first destination cell
(the first cell of the row or column into which you want to paste your data),
and then click Paste Special.
In the Paste Special dialog box, select Transpose, and then click OK.
You'll find theTranspose check box in the lower-right corner of the dialog
box:

Signature

~Anne Troy
www.OfficeArticles.com

> I have a spreadsheet that contains 45 rows and 90 columns. I need to make the
> rows into 45 columns and the columns into 90 rows.

Reply to this Message