Forum Discussion
How to combine the rows in multiple worksheets into one master sheet?
LegalSculptor First of all, Excel for Mac doesn't yet support all PQ functionality you may have read about. That said, why would you maintain two separate sheets, wanting to create a third as a master? Put all in one sheet, add a column for the category and work with that.
- This is not helpful. I'm in a similar situation as OP. We have a project document with separate tabs for each project manager, but we want to see a consolidated list of all active projects. I'm trying to pull the data from each tab into a single worksheet but I can't find a simple solution. The column headings are all the same.
Using a single worksheet isn't practical since each project manager edits/manages their projects individually. But we do need an overarching status of each project.PoKaroo Are you also using a Mac?
Riny_van_Eekelen Yes on mac. Version 16.64
- Unrestricted fully up to date Office 365 for Mac subscribers now have full PowerQuery capabilities.
JimGMac Which "unrestricted" version would that be. I'm on 16.64 (22073100). It certainly has a great deal of PQ but I wouldn't call it "full capabilities". Am I missing out on something?
I think all the functionality, including DAX, are supported in Mac Excel PowerQuery. Are you aware of something missing?
Riny_van_Eekelen That certainly makes sense. But my employer prefers that it is presented in this manner (simply pivoting on one worksheet is not desirable.) 🤷🏽:male_sign:
LegalSculptor Perhaps convince your employer that he/she is wrong.
