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.

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:

Read More: How to Transpose Rows to Columns Using Excel VBA (4 Ideal Examples)

Similar Readings

• How to Transpose Duplicate Rows to Columns in Excel (4 Ways)
• Excel VBA: Transpose Multiple Rows in Group to Columns
• Transpose Multiple Columns into One Column in Excel (3 Handy Methods)
• How to Reverse Transpose in Excel (3 Simple Methods)

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 ➤

After hitting the Transpose command, your rows will be instantly transformed into columns like the image below:

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

The 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

• Convert Columns to Rows in Excel Using Power Query
• How to Convert Columns to Rows in Excel Based On Cell Value
• VBA to Transpose Multiple Columns into Rows in Excel (2 Methods)
• How to Convert Column to Comma Separated List With Single Quotes
• Excel Paste Transpose Shortcut: 4 Easy Ways to Use
• Excel Transpose Formulas Without Changing References (4 Easy Ways)
• How to Transpose in Excel VBA (3 Methods)