Forum Discussion
How to combine the rows in multiple worksheets into one master sheet?
Apologies if the solution is trivially obvious but for the life of me I can't find the solution. Here is the problem: I have two worksheets functioning as a document log of sorts. Each worksheet ...
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.
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.