Transposing data is easy using the built-in Transpose feature, but there's another way. You can use Paste to transpose data!
You read the title right--the only thing that would make transposing easier would be a magic blink. To tell the truth, transposing data has never been difficult using Excel's built-in feature. There's also a second method via the Paste command and it takes just a few clicks.
Let's walk through a simple example in Excel 2010:
That's it! Excel's Paste feature quickly transposes the data. You can also do this in Excel 2003. First, copy the data and select a blank cell. Then, choose Paste Special from the Edit menu, check the Transpose option, and click OK.
- First, select the data (table, spreadsheet) that you want to transpose and copy it to the Clipboard using [Ctrl]+C. For instance, the example table (shown below) is in A1:E7.
- Select the top-left cell of the range you want to copy the transposed data to (A9 for instance).
- Click the Home tab (if necessary).
- Click the Paste dropdown in the Clipboard group.
- Click Transpose (the last icon on the second row).
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.