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]

try Alt D P for pivot

 

[CA_Punit]

The is a perfect example for Power Qwery. See Videos of Merge using Tables in You-Tube

 

[sandy666]

The is a perfect example for Power Qwery. See Videos of Merge using Tables in You-Tube

Can this be done without the later power query function?

 

[CA_Punit]

Oh i didn't read . Sorry Sorry..

 

[Dave Patton]

Not to add confusion but what does
"Can this be done without the later power query function?"

This function may be part of Excel 2010; you may need to activate it.

 

[Fluff]

Pretty sure it was only available as an add-in until 2016.

 

[sandy666]

XL 2010 doesn't contain Power Query. for this version PQ add-in is required if you want use it
but OP said

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

 

[sandy666]

as I said in post#2
try Alt D P and it will give an option to create pivot table from ranges

 

[Kibl1]

Wow that was quick.

I'm not certain when the power query came about but i know it is not in the version of Excel i am using unfortunately.

I will give the first method a try.

If my tables (all called Table1) are stored in a folder with a filepath say "dtt//Shared Folder" and called "Sales Sheet 1", "Sales Sheet 2" and "Sales Sheet 3" then what would i use for the data range to get it to recognise all 3 tables (assume A1:E20 is the data range in each table)?