I have two tables that utilize ‘Series to Row’ to format the table (see picture):
Table 1 has columns Time and Val1, Table2 has columns Time and Val2. I would like to merge these tables to one table with columns Time, Val1 and Val2.
I cannot figure out how to do this merge.
When I use both queries in the table, I end up with the following table that only has two columns:
Any guidance on how to properly due the merge described above would be appreciated.