Pivot Table

[Naga]

Hi all,
I am using Pivot to "table" my datas. It worked well before as my datas are
not exceding 1 page. Now I got about 100,000 set data set. How should I link
them together? Any example?
Thanks

 

[Debra Dalgleish]

You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:

http://www.contextures.com/xlPivot08.html

 

[Naga]

Thanks Debra,
But What I need is a matrix. It gives me a table.
Please see the example.

Sheet1
From To
1 1
2 1
1 2
2 1

Sheet2
From To
1 1
2 1
1 2
2 1

And I expect the outcome should be

To
From
1 2
1 2 2
2 2 2

But I got,
Row
Col
1 4
2 4


Any Help?
Thanks