Trying to figure out how to create a text value in a cell that consists of a pipe (|) separated list of unique values from a range of cells in column. I have a cell in one sheet that I would like to look like this:
from a range of cells that looks like this:
I need a function or macro that takes the start and end cell of a range and returns a single string value with the pipe separator. Any ideas or pointers to examples would be great!