Turn a horizontal list into a vertical one and vice versa with paste special transpose.

lets say you have a list of values in a spreadsheet that is going along a row like below:

10  20  30  40  50  60

But you want the list to be formatted like this:


Normally you would end up retyping the list of doing a lot copy and pasting.  Well you don’t have too do this!  You can use paste special to solve your problem. 

Highlight the text you want to rotate
select copy from the right click menu or from the toolbar / ribbon at the top of excel
move to where you want the new rotated list to be on your spreadsheet
select paste special from the right click menu of from the toolbar / ribbon at the top
tick the box at the bottom right of the screen that states ‘Transpose’
press ok.

This method will also change a vertical list into a horizontal list.

We are offering some FREE webinars too (see below)

Leave a Reply