How to Transpose Excel Columns to Rows

Here is a tip on how to transpose Excel columns to rows. For a certain purpose, maybe your table is better as it is, but when you want to use the data for analysis, it is suddenly more practical to transpose it.

This is a trick that I have thought about many times but never decided to solve. It has, in fact, a very simple solution.

I execute it on Mac but the same function is available on PC.

Here is the table I want to transpose.

 

Table to transpose
Table to transpose

Step 1: Select your data

First, you need to select the table data you want to transpose.

Select your data
Select your data

Step 2: Copy your data

Then, type Control + C (PC) or Command + C (Mac)

Step 4: Select the top-left cell of the destination table for your copy

Selecting the top cell for the destination of the new table
Selecting the top cell for the destination of the new table

Step 3: Display the various pasting options

Select the Transpose type of pasting for your data
Select the Transpose type of pasting for your data

Step 5: Paste using the “transpose” solution

Enjoy your newly made transposed table. In my table the example is simple, but imagine the headache you will save on a 20+ column wide 100+ long table.

Do you have any easier way to do it? Do you have other itches bothering you with Excel or Office Suite? Please leave a comment below :).

 

 

 

About the author

Share on

You may also like

Happy New Year 2020!

Dear Friend, I hope that you’ve had a wonderful end of 2019, celebrating with your friends or relatives 🎉🍾🥳🎅.

It takes trials, not failures to succeed

Words matter hugely. Choosing the right words can change your state of mind from positive to negative, without any intrinsic change in your situation.

Liked This Article?

We have a lot more where that came from! Join the many subscribers who stay ahead of the pack.

One Response

  1. I use the special paste for that, if you are quick with keyboard shortcuts it might save you quite some time! alt-e-s and then e (for the transpose part) but the shortcut can vary if you use another language.

Leave a Reply