Hi Catalin, I eventually figured out a solution to my issue without having to "remember" a prior value in a cell. But along the way, I came across...
Hi Mynda, Thanks for your suggestion about turning off Background Data in Power Query. That was a game changer! That's the only change I made and...
Hi Mynda, To speed up performance of my small example, I tried converting all the Excel tables to external .CSV sources and then updating my querie...
Mynda - Thank you for your pragmatic reply. At least I wasn't off base in suggesting my proposed course of data manipulation. Blanka - Thank you t...
In thinking about this further, and doing more searching, I found that if one adds a hidden helper column, which is the concatenation of all the rows ...
Ah, it looks like the Reference function will let me do a "Close/Load To" rather than the Duplicate function, which seems to preserve all the settings...
Hi Mynda, Yes, thank you for your response. The worked out example was enough for me to further the solution of this example. More importantly, it ...
Hi Mynda, Unfortunately, I might still need pointing in the right direction. Also, I don't know if I did a good enough job at highlighting al...
Hi Mynda, Thank you for your quick reply. Since I signed up, but haven't taken the Power Query course yet, it took me a while to review your ...