Combining Data and Dates from two different tables

you might try,

in query editor to un-pivot both tables

then merge tables

in a database one can't do that but here in Power BI the simple ordering of the rows may allow that to work

Assuming that your tables' layout will always match at a cell level (as you show it in your dummy data), I would unpivot both tables, add an index column, then merge on the index column.  This should get all the values for each date in the appropriate rows.

jdata  assuming your data does match as dkay84_PowerBI says

all you really need is the Index in each table - duh! :smileywink: