Pivot table - multiple data sources

[Derrick]

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

 

[Bill>M]

www.contextures.com/tiptech.html Try getting in touch with Debra Dalgleish
if you dont get your answers on her site, she will stear you in the right
direction.

 

[Ed Ferrero]

Hi Derrick,

I don't know if this is the best way, but it works for me. Assumes that you
have two spreadsheets with same column headings.

1) Save each data spreadsheet as a csv file - this is comma delimited text
i.e. Say you have two spreadsheets, save them as data1.csv and data2.csv
say the path is C:\MyData\

2) Open a DOS window (Start menu, run cmd)
enter these two commands
cd C:\MyData\
copy *.csv allData.csv

Now allData.csv has the combined data.

3) Build a pivot table using external data source allData.csv

Ed Ferrero
www.edferrero.com