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

Find the video lesson that you want – Index to all Excel Topics