An even EASIER question HELP!

[yaunus]

I have one simple question that I'd like help with.

How do I copy the contents of a ROW and paste them into a COLUMN?

for example:

1 | 2 | 3 | 4 | 5

into:

1
-
2
-
3
-
4
-
5


thx!
Ian

 

[J.E. McGimpsey]

Copy your cells. Select your top destination cell (can't be in the
copied range). Choose Edit/Paste Special and check the Transpose
checkbox.

 

[The Red Cardinal]

I have one simple question that I'd like help with.

How do I copy the contents of a ROW and paste them into a COLUMN?

for example:

1 | 2 | 3 | 4 | 5

into:

1
-
2
-
3
-
4
-
5


thx!
Ian

If you want it done automatically and to update itself etc, you can use the
TRANSPOSE function. For this though you need to enter it as an array formula
so if this is how you want it as opposed to the one-off method already
suggested then let post here...