Combine Tables Excel 2010

[Kibl1]

Hi,

I am using Excel 2010 and have no access to install add ins.

I have several tables i need to merge into 1 for MI (stored in a shared folder in different workbooks).

The tables are typically the same but users can add columns to them. E.g. if the tables were for fruit sales then it may have apples, oranges, pears, and a user may then add pineapples which would be a unique column on their table.

In order to analyse the data i need to amalgamate these tables into one master that includes all columns from each table so i can create a pivot table from this to query sales data.

I have searched for a solution and thought this would be straight forward but evidently not.

Can this be done without the later power query function?

 

[sandy666]

here is a link to the Power Query add-in for Excel 2010 / 2013
PowerQuery add-in for XL 2010/2013, all above has PQ built-in
=======
if you trying to use Alt D P you'll need select each range then add and again for the next range
it doesn't give you access through the filepath (what is possible with Power Query)

also you can try use vba but this is not my story, sorry

btw. address the post to whom you reply