Excel: pivot from large data

K

karrie

I have data of more than 66000 rows in more than one sheet with same column
headings. Can I combine them to form a single pivot table?
 
J

JP

Start creating your PT, then use multiple consolidation ranges and
specify the ranges from each worksheet.

--JP
 
R

ryguy7272

Yes, of coures. A source for a Pivot Table could be an Access DB, SQL
Server, etc. You could conceivable have millions or rows, which may
consolidate to just a few thousand rows, or maybe even a few hundred rown, in
an Excel Pivot Table.

Look at these examples
http://www.babeled.com/2008/07/18/excel-pivot-table-tutorial-wizard-usage-and-basic-manipulation/

http://peltiertech.com/Excel/Pivots/pivottables.htm

A little more advanced:
http://office.microsoft.com/en-us/excel/HP051993041033.aspx

http://www.associatedcontent.com/article/295956/creating_a_pivot_table_from_an_external.html?cat=59


HTH,
Ryan--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge 2 datasheets into single Pivot Table. 2
Combine Pivot tables - confused about 'how-to' 7
Workbook pivot table design function 6
Pivot using 250,000 rows of data in Excel? 1
Pivot Excel 2007 2
Multiple pivot tables 2
Pre-configuring Pivot table "views" 4
Help using Pivot Tables 5

Top