I'm new to Power Query and have what might be a basic question. I have my data in the following format:
Company Sales
Company A 100
Company B (division 1) 200
Company B (division 2) 300
Company B (division 3) 400
Company C 500
Company D 600
Company E (division 1) 100
Company E (division 2) 200
(Sorry, I'm not sure how to properly format a table)
Is there a way to transform my data so that Company E divisions 1 and 2 are aggregated into a Company E row and similarly with Company B divisions 1, 2 and 3?
I've cross-posted my question here:
https://www.reddit.com/r/excel/comme..._power_query/?
https://www.mrexcel.com/board/thread...query.1120201/
Bookmarks