Select Page

10 Awesome Excel Tips: Paste Transpose

by | Jul 24, 2022 | Excel Tips, Walkthroughs / Tutorials | 0 comments

Let’s say you want cells that are currently vertically in a column, horizontally in a row – let’s learn how to use “paste transpose” to prepare the data in the desired format.

One thing you can do is, select the relevant cells. Then copy them.

Next select the cell you want to start your row in.

Using Paste Transpose

Now do a ‘Paste’ ‘Transpose’. Go to ‘Paste’ and select ‘Transpose’. It has arrows going vertically and horizontally. This will transpose our cells.

Paste transpose in action

As you might have guessed it also works in reverse. If you want to go from a row to a column. We’ll copy our relevant cells.

Then we can right-click and select ‘Transpose’. Now you’ve put your cells in a column.

Check out more paste tranpose resources from Microsoft.

I’m Peter Koebel. The owner of Data Sciencing Consultants.

If you have a challenge in your Excel spreadsheet that you need assistance with. You can contact me at 204-770-6437, or email me at Plus, you can visit our website

Looking for more fun with data? You might enjoy some of our other posts!

US Population Density Map using Tableau Join our founder, Peter Koebel as he demonstrates a population density map using Tableau. You've probably seen population density visualizations everywhere, but how can you use them in your own...

Datasciencing Customer Demographics with Power BI Join our founder, Peter Koebel, as he walks through datasciencing customer demographics with Power BI. Datasciencing can be tough, but does it have to be? Check out this demonstration...