Rows to Columns

[Walter Seaton]

I have data arranged in rows across a spread sheet, for example B2, C2, D2,
etc.
How can I change that to a column, for example A1, A2, A3, etc without
reentering all the data?

Thank you

 

[Jacob Skaria]

--Select B22. Copy the range
--Select A1. Right click>PasteSpecial>Transpose>OK

If this post helps click Yes

 

[ryguy7272]

There are two ways to do this. Use Jacob's suggestion, or use this:
http://www.techonthenet.com/excel/formulas/transpose.php

That will create an array and 'lock' your rows/columns. This offers more
protection so that parts of arrays can't be accidentally deleted.

HTH,
Ryan---

 

[Jan]

I have data arranged in rows across a spread sheet, for example B2, C2, D2,
etc.
How can I change that to a column, for example A1, A2, A3, etc without
reentering all the data?

Thank you

You can use an array formula

=transpose(a1:A10)

Higlight the activecell and the additional 9 columns (in the example
being 10 rows)

Press f2 to edit the transpose formula and then ctrl + shift + enter