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.
About David Ringstrom
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.