How to pivot a column into a row?

Question

I have an Excel document where all the data is in one column and I would like it to be in one row instead.

So, A1 remains at A1, A2 to B1, A3 to C1, A4 to D1 and so on until column A only has one populated cell.

Is there a tool or method to do this?

Search for "excel swap column to row" first answer => Switch (transpose) columns and rows — DavidPostill, Oct 7, 2014 at 14:06

Prasanna · Accepted Answer · 2014-10-07 14:09:07Z

1

this function that you are referring to is called "transpose". You can transpose a row to make it into a column or a column into a row.

Copy the column (as in your case) you want to change to rows.
Right click on excel.
In the menu that appears look for "Transpose" under Paste options. If you are using older versions of excel, then, from the right click menu - select paste special. In the dialog that appears look for the check box next to "Transpose". Select and click OK

answered Oct 7, 2014 at 14:09

Prasanna

4,0745 gold badges35 silver badges51 bronze badges

I'm sure that this is the right answer, but if you look at the OP's description of the desired result it would be a diagonal line not a row. :)
– EBGreen
Oct 7, 2014 at 14:12
Agreed. I'm wondering if his requirement was to bring the data diagonally or not. Could it possibly be typo? Its always easy to say A3->B3 - where as in reality it is A3->C1.
– Prasanna
Oct 7, 2014 at 14:19
Oh yeah it was sorry... it is supposed to be in one row.I tried the transpose thing but there aren't enough row slots to past it in, I currently have 21760 cells in A populated. The most that I can put in one row is only 16384.
– user3797758
Oct 7, 2014 at 16:28
I ended up spiting the document into two
– user3797758
Oct 7, 2014 at 18:56

Add a comment |

1 Answer 1