Table transpose

[Anonymous]

Hey All,

Struggeling to transpose a table.

The original table looks like below.

Employee Name	Department	Course	Date
A	D1	1	1/01/2018
A	D1	2	5/04/2017
C	D1	3	2/06/2019
D	D2	1	1/01/2018
D	D2	2	5/04/2017
D	D2	3	15/11/2016
D	D2	4	2/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 Name	Department	Course 1	Course 2	Course 3	Course 4
A	D1	1/01/2018	5/04/2017
B	D3
C	D1			2/06/2019
D	D2	1/01/2018	5/04/2017	15/11/2016	2/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

[Anonymous]

HI @Anonymous 

Use pivot column -->Course in power query 

In the  options select date

advance options  --> do not aggregate.

[MattAllington · Accepted solution]

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

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

[Anonymous]

@MattAllington 

Thanks Mate.

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

Cheers!
A