Merging three data tables with the same structure into one table

[fakor]

Hello, I am Fakor an avid fan of Excel. I am currently studying so I can become adept in its use. I know this is a great place to learn because of the quality of brains here.

I have attached a file with three sheets. I'd like to merge the tables in each sheet into one so I can use PowerPivot to summarize in Excel 2013.

 

[Khalid NGO]

Hello fakor, good day and welcome to the forum

I have used a helper column for count in each table, and merged all tables in a separate sheet with simple IFERROR(INDEX/MATCH....)

I am not sure about your expected result, see if the attached file meets your requirement.

Regards,

 

[bobhc]

This link and video may help

http://stackoverflow.com/questions/...xcel-tables-based-on-matching-data-in-columns

.