Looking for a way to concatenate multiple values that are returned by a lookup or index/match function.
I have a column of dates, and a column of statuses. I want to return every status, concatenated by CHAR(10), for the highest date.
Unconcatenated, it looks like this:
That, of course, only returns one result.
Let me know if I can clarify anything!