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.
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.