Layered Unpivot

[peterpan]

I have a dataset in following format-

Client	Project	Workflow
HAL	Process Overview	A
HAL	Process Overview	B
HAL	Diligence	C
HAL	Diligence	D
HAL	Diligence	E
CAL	Audit	F
CAL	Audit	G
CAL	Audit	H
CAL	Compliance	I
CAL	Compliance	J

And I want it in following format-

HAL	Process Overview	Diligence	CAL	Audit	Compliance
Process Overview	A	C	Audit	F	I
Diligence	B	D	Compliance	G	J
		E		H

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.