Table Extract help please

[Daka]

Say I have a Master table in Excel. The column headers are A, B, C, D, E, F and G

The rows simply have numbers in them
Master table is to be populated from sub-tables

Sub-table 1 has column headers A,B,D,E,G
Sub-table 2 has column headers B,C,E,F
Sub-table 3 has column headers B,G

There are values in the sub-tables, let's say they all have 10 rows of data.

How do I populate the Master table from the sub-table? (happy to do 1 sub-table at a time). Ultimately I need to automate the process using macros.

I tried the Advanced Filter function but since the Master table will have more headers than the sub-tables have I get an error message.

I tried using Power Query but just could not get the macros to work because each sub-table is of varying sizes.


Would realty appreciate your help ..... How do I populate the Master table from the sub-table?

Thanks

 

[alansidman]

this may be a Power Query solution. Can you provide some sample data using XL2BB so that we won't have to recreate your data.