Hello everyone
i have 8 sheet (ZSC, MBZ, NAH, MAK, RAS, HNZ, KBZ, SHA) that are exactly the same but for different venues
Each sheet has 9 subjects, ( each subject will have different number of row under them depending on teh sheet)
- MATV
- CCTV
- TV Lighting
- Audio
- Comms
- SIM Trans
- HAwk Eye
- Pitch Side LED
- Power
i want to create a pivot table that will allow me to view the combine data from the 8 sheet according to the 9 subjects.
i have attached the excel file that i am working on at the moment for reference
Bookmarks