
william barker
Active Member
Members

Forum Posts: 4
Member Since:
October 12, 2019
October 12, 2019

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

Mynda Treacy
Admin

Forum Posts: 4515
Member Since:
July 16, 2010
July 16, 2010

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

Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793
Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
