let
Source = Table.Combine({Table1, Table3, Table5, Table7})
in
Source
Why. Would not the simplest solution be the best solution. Code will be more lengthy and convoluted. You will need a Pivot Table to consolidate the data. Here is another alternate solution.thanks, but i hoping works by code