Multiple sheet and consolidated database

[kingtoni]

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!