Forum Discussion

M_Butler's avatar
M_Butler
Frequent Visitor
2 years ago
Solved

Power Query - Pivoting Data

Hi,

 

I have this data:

 

DateProductVolume
8/04/2024A10
8/04/2024B20
9/04/2024A10
9/04/2024C30
10/04/2024A5

 

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

 

DateABC
8/04/202410200
9/04/202410030
10/04/2024500


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

 

Any ideas? TIA!

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    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