Transposing Data in Excel Worksheets

exceltips.jpg

Spreadsheets and graphs on a desk
xfgiro/istock
Share this content
3

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.

Replies

Please login or register to join the discussion.

Thank you for sharing the good info

Thanks (0)

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

http://www.itsupportforum.net/...

Thanks (0)

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)