creating pivot table with similar columnames

[s.rijnders]

hello,

i have the following problem :

i am using extremely large excel sheets with specific data in it.
i can report approx 10 weeks into one sheet before it is full. then i
need to use a 2nd sheet.

i want to combine those sheets into 1 pivot table, but the layout of
the sheets is exactly the same (and that should stay this way)

when creating a pivot table with multiple ranges i get an error
message that there are similar column names. is there a away to allow
this and to combine those columns ?

for example in sheet 1 there is a lot data from week 1 to 9.
sheets 2 is containing data from week 9 to 19.

so for week 9 there data in both sheets.
i want to create a pivot table that combines this.
so 1 column name with week 9 and from there the calculation from both
sheets.

is that possible ?

thanxxx a million !!!

 

[Guest]

The only option I can think of is to import those two tables into Access,
create a Union query and run the pivot table off that union query as your
data source.

You may be able to use Excel's MS Query tool to do a similar thing, however
I've never used it.

Dave