Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Table transpose

Hey All,

Struggeling to transpose a table.

The original table looks like below.

Employee NameDepartmentCourseDate
AD111/01/2018
AD125/04/2017
CD132/06/2019
DD211/01/2018
DD225/04/2017
DD2315/11/2016
DD242/06/2019

There are more columns, which I want to hide. Also, there are more than 4 courses, which I want to filter the redundant ones.

I want to achieve this view

Employee NameDepartmentCourse 1Course 2Course 3Course 4
AD11/01/20185/04/2017  
BD3    
CD1  2/06/2019 
DD21/01/20185/04/201715/11/20162/06/2019

 

Showing Department, and maybe other columns. Also, Showing Employees without data (empty values), like employee B above.

 

Any hint would be much appreciated.

 

Thanks!
A

1 ACCEPTED SOLUTION
MattAllington
Community Champion
Community Champion

This looks like pivoting text data to me. Read my article here. 

https://exceleratorbi.com.au/pivoting-text-data-using-power-query/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

HI @Anonymous 

Capture2.GIF

Use pivot column -->Course in power query 

In the  options select date

advance options  --> do not aggregate.

 

MattAllington
Community Champion
Community Champion

This looks like pivoting text data to me. Read my article here. 

https://exceleratorbi.com.au/pivoting-text-data-using-power-query/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.
Anonymous
Not applicable

@MattAllington 

Thanks Mate.

Apparently, I was missing the do not aggregate thingi which messed up my visual.

 

Cheers!
A

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!