Combine (Concatenate) Text or Values from Two or More Cells into Dropdown List Column

Heather Taylor

Is it possible to Combine (Concatenate) Text or Values from Two or More Cells into Dropdown List Column (allow multiple values per cell) and have it display as separate entries? I am aware of how to combine using spaces, dashes, commas..I just want it to have this view (see picture).

Paul Newcome

You would use this as your delimiter:

CHAR(10)

Paul Newcome

You would use this as your delimiter:

CHAR(10)

Heather Taylor

I swear that I tried that first! Thank you!!!

Paul Newcome

Happy to help. 👍️