Excel - is possible to switch 2 rows to be 2 columns ( 1&2 -> A&B) 4

[hallux]

If there are two rows full of data (Row 1 & 2) and I would like to move it to populate two columns (A & B), is that possible in Excel? I thought there was a feature or maybe copy/paste special, but didn't find it.
Thanks,
-Hallux

 

[bluedragon2]

You can do this by copy/paste special/transpose

But, if you have formulas in there, their may be some problems with reference...



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[ETID]

Yes copy/paste special>...check the transpose box

 

[hallux]

Thank you.
That is exactly what I needed. Any ideas why Microsoft chose the word "transpose"? Maybe I just keep thinking of transposing music.
-Hallux

 

[Zathras]

From The American Heritage® Dictionary of the English Language, Fourth Edition:

transpose: ....Mathematics....A matrix formed by interchanging the rows and columns of a given matrix.....