Transposing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Deena

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

thanks,

Shail
 
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort entire row of data to top of sheet automatically 16
remove contain from rows B thur J 2
If 3 If's, then sum 13
Help for Time tracker updation 1
Need transpose? help.... 9
LINEST multiple known_x's separated arrays 5
Help with Vlookup 1
Transpose Formula onto New Sheet 2

Back
Top