Hello,
I have multiple tables within a single excel spreadsheet that I would like to consolidate into a single pivot table. I know using PivotTable Wizard I can do this for numerical data. However, I would like to analyse the multiple tables based on month, i.e. a Pivot which would have 'Project' as the rows and 'Month' as the columns. Is this possible without going into the World of VBA? Many thanks
I have multiple tables within a single excel spreadsheet that I would like to consolidate into a single pivot table. I know using PivotTable Wizard I can do this for numerical data. However, I would like to analyse the multiple tables based on month, i.e. a Pivot which would have 'Project' as the rows and 'Month' as the columns. Is this possible without going into the World of VBA? Many thanks