Not sure if I've understood your requirements well.
Partly based on my guess, I created a sample for your reference.
Please refer to the attached workbook for the details.
help-with-columns.twbx 21.9 KB
Hey turns out that's exactly what I was doing! It was something else that was the problem... but it's good you've confirmed my method!