Power Query or Macro to Aggregate Tables

[gitmeto]

I am in the process of considering options to consolidate data from multiple tables. The tables have all the same structure (column labels and number of columns). In total there are 31 tables that need to be aggregated. However, although the structure is consistent, the data is indexed by date and there is variability as to the start date for each table. I thought that PQ would be the answer but it seems as though it will only aggregate data that is consistent or matching, meaning if the dates do not match it will not aggregate the data. Unless there is a way to aggregate data, my other option would be to run a macro, index each table by the date and grab the info to populate a table.

Is there a way to aggregate data that have different number of rows, or does this follow general matrix rules, same number of rows and same number of columns?

 

[gitmeto]

@severynm, I am not sure what value posting the data would provide. It should be a simple merge based on columns that I select given the description of a full join. I went ahead and built the tables using a macro.

I appreciate your willingness to help.

Stay well!