Hi everyone,
Second time having to ask for help with something fairly unique. Maybe an array isn't even the solution and it would be more like a udf, but I thought it was worth a shot.
Anyway, I am looking for something that would return a unique list of values after concatenation of columns. I am familiar with arrays to pull unique lists, even from multiple columns, but not one that would do the actual concatenation and then pull the unique values from that. The issue I am hitting is that I am not able to utilize helper columns in this scenario.
Breakdown would be something similar to the attachment.
Help is always appreciated,
Thank you,
Bookmarks