Infero Training – Business and Technical Courses

Suppose you need to shift the content of rows with the content of columns. What shall you do?

The Transpose option shifts rows and columns on the worksheet. For example, if you have a table where the months appear as rows and the sales as columns, the transpose option will reverse the rows and columns.

You need to do the following:

1. Select the range you want to change
2. From the Home tab in the Clipboard group, click the Copy button
3. Select a cell outside of the range you copied
4. In the Clipboard group, click the Paste drop-down arrow and select Transpose