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/