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

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.


Download Practice Workbook

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


Quick Steps to Transpose Rows to Columns in Excel Using Power Query

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 (4 Ideal Examples)


Similar Readings


Step-2: Applying Transpose Command to Transpose 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: Close & Load 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


Practice Section

You will get an Excel sheet like the following screenshot, at the end of the provided Excel file. Where you can practice all the methods discussed in this article.


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. And please visit our website Exceldemy to explore more.


Related Articles

Mrinmoy

Mrinmoy

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

ExcelDemy
Logo