This is essentially Excel, merge two sheets with one column as key but instead of one key column I have 3 so I cannot simply use
What I want is very simple: dynamically generate a master table with all the data from a set of tables combined. It should be very easy to include new rows that are added to the source tables. Eventually I will do a pivot table on the master table to get the final form as shown.
Source table structure: Date | Product | Variant | Price Desired master structure: Source table name* | Date | Product | Variant | Price Final form Date | Product | Variant | Source1 | Source2 | SourceN
*The source table name can be added to the source table.