Pivot Option in power bi backend

[paw1]

Hi,

Can any one please help me on below requirement. I have a source like below. Please help me to pivot status and Date columns like in expected output in power query editor. I can see only unpivot option in power query.

Input:

Main ID	step no	status	Date
11	10	On Hold	14/11/2022 08:29:05
11	10	Resumed	14/11/2022 08:29:10
11	10	Complete	14/11/2022 08:29:15
11	10	Started	14/11/2022 08:29:00
11	23	Started	14/11/2022 09:29:00
11	23	Complete	14/11/2022 09:35:00

Expected output:

Main ID	step no	On Hold status	Resumed status	Complete Status	Started Status
11	10	14/11/2022 08:29:05	14/11/2022 08:29:10	14/11/2022 08:29:15	14/11/2022 08:29:00
11	23			14/11/2022 09:35:00	14/11/2022 09:29:00

[Anonymous · Accepted solution]

Hi @paw1 ,

I think you can select [Status] column and use "Pivot Column" function.

You can find it from Transform > Pivot Column in Power Query Editor.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.