I already have an Excel Power Query that draws data from a "loading zone" table. Later, I want to add a macro that will cause the query to refresh, add the new data, and then delete the loading zone rows.
I required commenting to be available, and by self-referencing this query and extracting the manually made comments column, I was able to make commenting available. The query returns these and other rows.
![RawQuery](https://i.stack.imgur.com/gvABD.png)
With Power Query, I'm attempting to have it seek up comments for the same Device ID from the prior week.
As a result, "presenting concerns" should be Row 6's Last Week Comment value. There shouldn't be anything for the others since there were none last week.
The majority of available solutions, which I would prefer to avoid, are for Power BI and DAX setups.