How to Use the Transpose Function in Excel

By Shreya Mehta

The transpose function in Microsoft Excel is very useful in transforming rows of data into columns or columns into rows. It saves users a lot of time by eliminating the need to manually transpose the data, and is especially useful when transposing many rows or columns of data. You may need to use this feature when consolidating rows of data into a single column to perform a calculation, or break a column of data into different rows. Learn how to use the transpose function in Microsoft Excel by following the easy steps below.

Step 1

Highlight the range of cells where you want the transposed data to appear. For example, if you want to transpose cells A1:A10 into a row in cells B1:K1, you would highlight B1:K1.

Step 2

Go to the "Formulas" tab and click on "Insert Function." Type "Transpose" in the "Search for a function" field and click on the "Go" button. Select "Transpose" from the "Select a function" section and click "OK."

Step 3

Highlight the range of cells you would like to transpose. In our example, we would highlight cells A1 through A10. The range will appear in the "Array" field of the Function Arguments window.

Step 4

Hit "Ctrl," "Shift" and "Enter" on your keyboard simultaneously. The transposed data will appear in the new location, which is B1 through K1 in the example.

References & Resources