Power Pivot and Data Model theory

Hi,

I have 4 spreadsheets, duplicate table structure with unique employee names and id's. Table rows for each are between 400K and 680K rows. Because of the sizes I am unable to combine the sheets into one table.

I would like to combine the tables/data to make one pivot table.

I have only been looking at Power Pivot and Data Model for the last day or so but I am having trouble grasping the concept.

I think I get it when unique tables and data are used.

But I can't find anything online that shows me if what I want to do is possible with either PP or DM.

I am attaching a spreadsheet with two mini tables and a sample of the kind of pivot I am interested in building.

If someone can explain or show me if combining data like this is possible I would very much appreciate it.

Regards, Brenda

Thank you mikeTRON! I read the article and with a little work I managed to successfully implement the CSV method. And somewhere in those travels I came across this - http://www.contextures.com/PowerPivo...cel-Files.html
In all honesty I do prefer the Contextures method with one exception - the error I keep getting when I try to edit the SQL statement as per the Contextures site.
First, I am not clear on why this is done. And I don't know how to resolve the error I am getting and Googling/Youtubing it hasn't shed any light on it.
I am attaching a snagged image of my error.
If you can help me out again with one or both of these dilemmas I'd really appreciate it.
Thanks for your time.
Brenda

Thanks xlnitwit.
It appears that Power Query is an add in?
If so I am unable to download it at work because our systems are locked.
I have however tried both the CSV and Contextures techniques but as in my reply to mikeTRON I am unable to resolve an error I am getting with SQL validation. Maybe you might accept my challenge and help me figure it out?
Thank you for your reply earlier today, regardless of whether you look at this SDQL issue.
Your time and interest is very much appreciated.
Regards, Brenda

No, it's only available in 2016. It needs to be installed in 2013. And again, at work that isn't an option unfortunately.