Hi,

I believe this is a question that has been raised many times, but somehow I
still couldn't find the solution.

I've a spreadsheet which I have to split into 2 because it exceeded the 65k
lines.

I need to create a pivot table to merge the data together. I couldn't use
the multiple consolidation because of the limitations.

The alternative is to create 2 pivot tables and merge the data from the two
tables into a third pivot table but that's just silly.

I would appreciate any advise.

Many Thanks