Hi @ScottF and @TardisPilot,
This might be close - “Loop in KNIME on a list of unique values”
Merges two columns into one by choosing the cell that is non-missing.
Loop in loop with “table row to variable loop start”: problems accessing flow variables
It all looks promising.