Power BITutorials

Power Query Helps In Transposing Data

1 Mins read

Transposing a data set is ultimately rotating data from rows to columns, or from columns to rows. To understand this concept, an example with the picture is given below.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Transposing Data By Power Query

Step 1: Open the data in Power Query

Open the data set in Power Query that you want to transpose. The picture below shows the data that we want to transpose. We will transpose this data to rotate it from rows to columns.

BEFORE TRANSPOSING DATA

Step 2: Transpose the data table

Select Transform > Transpose

TRANSPOSE DATA

It flips the data from rows to columns. Power BI Transpose option works on the entire Data table as shown in the below picture.

Note: When you transpose the data table, it eliminates the existing column headers and replaces it with the default Power Query column headers like Column1, Column2….and so on.

AFTER TRANSPOSING DATA

Step 3: Use first rows as headers

Go to Transform > Use First Row as Headers button > Use First Row as Headers option

USE FIRST ROW AS HEADERS

This will show all the details of individuals column-wise.

Step 4: Close & Apply

Click Close & Apply from the Home tab and this will apply all the pending changes on your transposed data.

TRANSPOSED DATA AFTER CHANGING ROW HEADERS

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…