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:
- 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.
- 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:
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.
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.
- 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)