Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Switching Rows/Columns

0 views
Skip to first unread message

Justin

unread,
Sep 22, 2004, 9:18:54 PM9/22/04
to
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

unread,
Sep 22, 2004, 9:59:31 PM9/22/04
to
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

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
"Justin" <anon...@discussions.microsoft.com> wrote in message
news:426901c4a10b$4ad91770$a501...@phx.gbl...

justin

unread,
Sep 22, 2004, 10:06:50 PM9/22/04
to
nevermind
>.
>

Max

unread,
Sep 22, 2004, 11:34:40 PM9/22/04
to
"justin" <anon...@discussions.microsoft.com> wrote
...
> nevermind

Copy > paste special > transpose > OK

(For a one-time adhoc job)

Biff

unread,
Sep 22, 2004, 11:42:09 PM9/22/04
to
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

>.
>

0 new messages