Power Query - Pivoting Data

[M_Butler]

Hi,

I have this data:

Date	Product	Volume
8/04/2024	A	10
8/04/2024	B	20
9/04/2024	A	10
9/04/2024	C	30
10/04/2024	A	5

I would like to use Power Query to convert it into this format:

Date	A	B	C
8/04/2024	10	20	0
9/04/2024	10	0	30
10/04/2024	5	0	0

I have tried using transpose/unpivot but I am not getting the desired results unfortunately.

Any ideas? TIA!

[Ritaf1983 · Accepted solution]

Hi @M_Butler 
You need to pivot the column product :

after this replace null with 0

pbix is attached

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

[M_Butler]

Amazing, thank you so much!

[Ritaf1983]

Happy to help 🙂