An even EASIER question HELP!

  • Thread starter Thread starter yaunus
  • Start date Start date
Y

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
 
Copy your cells. Select your top destination cell (can't be in the
copied range). Choose Edit/Paste Special and check the Transpose
checkbox.
 
yaunus said:
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
Click to expand...


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...
 
Back
Top