Dear Experts,
Need your help.
I have a excel sheet with very huge data. Data is scattered over multiple tabs. Data structure is same on all the tabs. I need to create a single pivot table for all tabs together. I tried for MS Query, it's not working for some strange reason, Syntax Error.
I tried Alt+D option for pivot wizard, it's having its own limitations, it's not allowing me to multiple columns as category.
Need your help.
I have a excel sheet with very huge data. Data is scattered over multiple tabs. Data structure is same on all the tabs. I need to create a single pivot table for all tabs together. I tried for MS Query, it's not working for some strange reason, Syntax Error.
I tried Alt+D option for pivot wizard, it's having its own limitations, it's not allowing me to multiple columns as category.