Transpose your data
You can turn your Excel data on its side – literally! When you use the Transpose option from the Paste Special dialog box you can turn data from a Horizontal Orientation to Vertical one – or vice versa. It’s easy to do this as you will see in this video.
Here are the steps to follow for today’s tip:
1) Select the data area and copy it to the clipboard
2) Right-click a blank cell in an open area of your worksheet
3) Select “paste special” and check the “transpose” box and then click OK
December 30th, 2009 at 1:42 PM
[...] Transpose Your Data [...]
December 30th, 2009 at 2:10 PM
[...] Transpose Your Data [...]
December 16th, 2010 at 9:02 AM
[...] Transpose Your Data [...]