Transposing Data in Excel Worksheets


Spreadsheets and graphs on a desk
Share this content

From time to time, you may encounter data that's presented in rows, when you actually need it to be in columns instead. Or you may wish to flip data in columns into a row format. Many users don't realize that Excel offers an easy way to accomplish this task with just a couple of mouse clicks. You can even create a keyboard shortcut in Excel 2007 and later. I'll also discuss a couple of frustrating nuances you may encounter when transposing data.

Let's assume that you have a list of car buyers and their vehicle information presented on two rows as we see in Figure 1. We'd like to transform this data into a columnar list, as shown in Figure 1, so that we can use the information to generate letters via Mail Merge in Microsoft Word. 

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.


Please login or register to join the discussion.

By webdesign
Jun 26th 2015 01:10

Thank you for sharing the good info

Thanks (0)
By Lewis
Jun 26th 2015 01:12

Just to re-iterate, it only works when you copy-paste, transpose doesn't work with CUT-paste, as per this article:

Thanks (0)
By David Ringstrom
Jun 26th 2015 01:12

You're absolutely right. Thanks for pointing out the omission. I'll update the end of the article to detail 3 quirks, with the fact that you can't Cut-and-Transpose being number 1.

Thanks (0)