Discussion Locked

Excel Rows to Colums

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
It should be easy, I just want to take a row(s) of information and make it a column. I know I have done it before but today, I must be brain dead.

3 replies

by dklippert

Select the Rows.
Copy the data.
Select the first cell of the target area.
Go to Edit>Paste Special and choose Transpose in the lower right corner of the dialog box.

by jobrika

Thanks, I must be brain dead. I have done it before, and just plan forgot the steps.

Thanks - John

This discussion is closed to new replies.