Notifications
Clear all
Power Query
6
Posts
3
Users
0
Reactions
84
Views
Topic starter
I have a Query in progress where I want to UnPivot but by Grouping as my Date values don't align.
Diagram1 is where I'm up to.
Diagram2 is the result I'm looking for.
What do I need to do to get from one to the other? TIA.
Posted : 22/05/2023 5:46 am
Rather than have us reenter all your data into a spreadsheet, instead of a picture, please upload your file so that we can manipulate the data. Help us to help you by making it easy for us.
Posted : 22/05/2023 3:46 pm
Topic starter
Good idea. See attached file as suggested.
Posted : 22/05/2023 6:14 pm
Please have a look at the attached file where I added a basic query that only involves clicking in the user interface. No M-coding required.
Posted : 23/05/2023 12:26 am
Topic starter
Fantastic Riny. Simple and exactly what I was after.
Posted : 23/05/2023 2:20 am
Glad I could help!
Posted : 23/05/2023 2:30 am
