How to transpose a row or column of data

Transposing a row involves converting the data in that row into a column; and vice-versa for transposing a column of data.

Ok. Let’s get to it. To transpose a row of data:

1. First select the data you want to transpose – see the diagram below.

2. Next, click the ‘Home’ tab on the ribbon

3. Click the ‘copy’ command

4. Then click where you want the transposed data to appear

How to transpose a row or column of data 2

5. Then, click on the drop-down arrow just under the ‘Paste’ command – see the diagram below.

A drop down box will appear

6. Click on the transpose command

How to transpose a row or column of data4

How to transpose a row or column of data 3

Excel will transpose the data for you. See the diagram above.

Lesson 27: How to change the Font (typeface) of a cell or range

Submit a Comment

Your email address will not be published. Required fields are marked *