Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
86
Views
Topic starter
Hello,
I have 3 sets of 36 columns that i would sum into 3 columns
36 month total sales history
36 month Processed sales history
36 month total validated forecast
With all sets of columns i am hoping power query can aggregate the data with columns that contain the same end text (without the date references) because they change monthly.
I did not see if power query has some type of wildcard functionality to look a the headers
* Processed Sales History
Posted : 12/10/2019 4:18 pm
Hi William,
Welcome to our forum!
Unpivot the values columns. Then split the column containing the label; Total Sales History, Processed sales history, total validated forecast. Then you can use GroupBy to summarise them. Then you can pivot the column containing the labels. See file attached.
Mynda
Posted : 12/10/2019 7:28 pm
Topic starter
Mynda,
This is exactly what i was looking for!
Thank you !
Bill
Posted : 13/10/2019 7:46 am
