Switching Rows/Columns

[Justin]

Hi,

I don't use Excel very much. I need to switch the rows
with the columns in a data block I have. I have ~100
columns and 3 rows. I want 3 columns and 100 rows. I
remember being able to do this easily in the past.
transpose or something? Any help will be apreciated.

 

[Max]

You may also like to try this ..

Assuming your data is in Sheet1, in A1:CV3 (3R x 100C)

In Sheet2
-------------
Put in A1: =OFFSET(Sheet1!$A$1,COLUMN(A1)-1,ROW(A1)-1)
Copy A1 across to C1, fill down to row100

The above will also produce the transpose (100R x 3C)
that you seek, which is dynamically linked to the original
data in Sheet1

 

[justin]

nevermind

 

[Max]

nevermind

Copy > paste special > transpose > OK

(For a one-time adhoc job)

 

[Biff]

Hi!

Select the data range and copy it.
Select the the cell where you'd like to copy the data to.
Since you want 3 columns make sure your destination range
has 3 cells empty to recieve the data.
Then do Edit>Paste Special>Transpose.
Then you can delete the data from it's original location.

Note: if your current data range starts in column A and
that is also where you'd like the transpose operation to
end up then simply insert 3 new columns at column A.

Biff