Forum Discussion
Remodel a table by calculating time difference
Hello, I have table 1 with Xvalue+ date when collected and table 2 with various Yvalues + date when been collected. I want to get a third table with a list of all single dates (+ Yv...
With Power Query you can add data to the blue dynamic tables (table1 and table2). Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. The green result table can stay to the right of the blue tables or it can be placed in another worksheet.