Change a Row to a Column or Column to a Row

Did you just type a bunch of data and realize you need it going from top to bottom instead of left to right? Never fear, Transpose is here!

1. Select and Copy the data to change

2. Right-click a cell where you want to start the new Row or Column

3. Select Paste Special

4. Put a check next to Transpose and hit OK

SideNote: Your new information can’t overlap your copied selection. If this causes an error, Paste Special->Transpose the data to a blank worksheet, then move it accordingly(a must if Transposing an entire column or row).

Leave a Comment