Pivot Tables

[Gealer]

Colleague	TEAM	Course id 123	Course id 124	Course id 125	Course id 126	Course id 127	Course id 128
Colleague 1	TEAM A	Successful	Successful	Successful	Successful	Successful	Successful
Colleague 2	TEAM B	In Progress	In Progress	Not Registered	Successful	Successful	In Progress
Colleague 3	TEAM C	Not Registered	Successful	Not Registered	Not Registered	Not Registered	Not Registered
Colleague 4	TEAM D	Successful	In Progress	Successful	Successful	Successful	Successful
Colleague 5	TEAM A	In Progress	Not Registered	In Progress	In Progress	In Progress	In Progress
Colleague 6	TEAM B	Not Registered	Successful	Not Registered	Not Registered	Not Registered	Not Registered
Colleague 7	TEAM C	Successful	In Progress	Successful	Successful	Successful	Successful
Colleague 8	TEAM D	In Progress	Not Registered	In Progress	In Progress	In Progress	In Progress
Colleague 9	TEAM A	Not Registered	Successful	Not Registered	Not Registered	Not Registered	Not Registered
Colleague 10	TEAM B	Successful	In Progress	Successful	Successful	Successful	Successful
Colleague 11	TEAM C	In Progress	Not Registered	In Progress	In Progress	In Progress	In Progress
Colleague 12	TEAM D	Not Registered	Successful	Not Registered	Successful	Successful	Not Registered
Colleague 13	TEAM A	Successful	In Progress	Successful	Successful	Successful	Successful
Colleague 14	TEAM B	In Progress	In Progress	In Progress	In Progress	In Progress	In Progress
Colleague 15	TEAM C	Not Registered	Not Registered	In Progress	Successful	Not Registered	Not Registered
Team A	Course id 123	Course id 124	Course id 125	Course id 126	Course id 127	Course id 128
Successful
In Progress
Not Registered
Team B
Successful
In Progress
Not Registered
Team C
Successful
In Progress
Not Registered
Team D
Successful
In Progress
Not Registered

<tbody>
</tbody>

I am new to using pivot tables but i have my data set at the top and would like the table at the bottom to be produced.

 

[sandy666]

if it's what you want, use PowerQuery to UnPivot table

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Colleague", "TEAM"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"[/SIZE]

then use Query Table for normal PivotTable

	Column Labels
Row Labels	Course id 123	Course id 124	Course id 125	Course id 126	Course id 127	Course id 128
TEAM A
In Progress
Not Registered
Successful
TEAM B
In Progress
Not Registered
Successful
TEAM C
In Progress
Not Registered
Successful
TEAM D
In Progress
Not Registered
Successful