Combining Data and Dates from two different tables

[jdata]

Hi,

I am looking to combine values and dates that are in two seperate tables.

In the first table, the rows contains time series data (fi data) for different companies (identifier in first column).  The second table is structured the same (identifiers in first column), except the cells contains dates that correspond to the data in the first table. 

Is there a way to combine these data so that I end up with a single table that has 3 colums as follows: 

Column 1: company identifier

Column 2: date

Column 3: Fi data

Thanks!

Jonathan

[CahabaData · Accepted solution]

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

[dkay84_PowerBI · Accepted solution]

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.