MarkCBB
Active Member
- Joined
- Apr 12, 2010
- Messages
- 497
Hi there,
I am new to Excel 2013, how do I add related data to an existing data model?
I have an excel workbook with 12 tabs, each tab has the same database structure but each tab is a different month, sheets have 900,000 rows each. I am looking for a way to add all of the databases into 1 pivot table so I can look at the whole year of data. I think the correct tern is join or union?
has anyone done this before? if so how do I go about doing it?
I am new to Excel 2013, how do I add related data to an existing data model?
I have an excel workbook with 12 tabs, each tab has the same database structure but each tab is a different month, sheets have 900,000 rows each. I am looking for a way to add all of the databases into 1 pivot table so I can look at the whole year of data. I think the correct tern is join or union?
has anyone done this before? if so how do I go about doing it?
