Excel Power Query: Transpose Rows to Columns (Step-by-Step)

Get FREE Advanced Excel Exercises with Solutions!

The Power Query in Excel makes the transformation from rows into columns very handy. In this article, you will learn to transpose rows to columns with a step-by-step guide using the Power Query in Excel.


Step 1: Inserting Data into Power Query to Transpose Rows to Columns in Excel

I have the following data table which I want to transpose.

Now I’m going to show you how to use the Power Query to transpose the rows into columns.

First, you have to insert the data into the Power Query Editor.

To do that,

  • Go to Data ➤ From Table/Range.

Inserting Data into Power Query to Transpose Rows to Columns in Excel

Create Table dialog box will appear.

  • Insert your table range and hit OK.

Now the Power Query Editor will automatically pull the data table into it. The result will look like this:

Inserting Data into Power Query to Transpose Rows to Columns in Excel

Read More: How to Transpose Rows to Columns Using Excel VBA 


Step 2: Applying Transpose Command to Convert Rows to Columns Using Power Query

Now it’s time to apply the Transpose command.

For that,

  • Go to Transform ➤

Applying Transpose Command to Transpose Rows to Columns Using Power QueryAfter hitting the Transpose command, your rows will be instantly transformed into columns like the image below:

Transpose Rows to Columns in Excel Using Power Query


Step 3: Closing & Loading to Transpose Rows to Columns in Excel

Now it’s time to close the Power Query Editor and take the transformed data into the Excel spreadsheet.

To do that,

  • Go to the Home tab first.
  • Then click on the Close & Load drop-down.
  • After that, click on the Close & Load

Close & Load to Transpose Rows to Columns in ExcelThe Power Query Editor will be closed off.

You will get your transformed data in a fresh spreadsheet like this:

Read More: Transpose Multiple Rows in Group to Columns in Excel


Download Practice Workbook

You can download the Excel file from the following link and practice along with it.


Conclusion

To sum up, we have discussed quick steps to transpose rows to columns in Excel using Power Query. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mrinmoy Roy
Mrinmoy Roy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

1 Comment
  1. Extremely helpful! Thank you!

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo