I have following problem.
I have multiple sheets that are identical. I've tried to use PivotTable wizard with multiple consolidation ranges to combine these databases. Thing is that it only understands the first column as a row field. My problem is that I have to use first and second columns as a row field. See my exaple:
Sheet1
Type - Costcenter - Jan - Feb - Mar - Q1
Sheet2
Type - Costcenter - Jan - Feb - Mar - Q1
Pivot or consolidated database:
Type1 - Costcenter1 - Jan - Feb - Mar - Q1
Type1 - Costcenter2 - Jan - Feb - Mar - Q1
Type2 - Costcenter1 - Jan - Feb - Mar - Q1
Type2 - Costcenter3 - Jan - Feb - Mar - Q1
Any help or ideas are very welcome!
I have multiple sheets that are identical. I've tried to use PivotTable wizard with multiple consolidation ranges to combine these databases. Thing is that it only understands the first column as a row field. My problem is that I have to use first and second columns as a row field. See my exaple:
Sheet1
Type - Costcenter - Jan - Feb - Mar - Q1
Sheet2
Type - Costcenter - Jan - Feb - Mar - Q1
Pivot or consolidated database:
Type1 - Costcenter1 - Jan - Feb - Mar - Q1
Type1 - Costcenter2 - Jan - Feb - Mar - Q1
Type2 - Costcenter1 - Jan - Feb - Mar - Q1
Type2 - Costcenter3 - Jan - Feb - Mar - Q1
Any help or ideas are very welcome!