Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining Pivot Tables - Summarising data from 100,000 rows
Hi All, I have a data set of around 100,000 rows which I have imported into excel in two sheets (~50,000 rows each). The data is not in a format that excel can easily parse into a pivot table directly from the source - it requires some formulae in excel to be able to use a pivot table. I have used a pivot table on each of those sheets to summarise the data, and that works fine. However, I would like to be able to get a single summary pivot table from the two sheets (or from the two pivot tables). Is that possible, and if so, how do I go about it? Thanks, Alan. |
#2
|
|||
|
|||
"Alan" wrote in message
...: {Bump} |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create one pivot from mulitple data sources | Excel Discussion (Misc queries) | |||
Do Pivot Tables have an automatic data range expansion? | Excel Discussion (Misc queries) | |||
Pivot Table Data | Excel Worksheet Functions | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
Pivot table retrieving data from several worksheets | Excel Worksheet Functions |