Cloud Structure: Display multi-select values into separate rows in a Formula

[Dubie]

Hi,

I have a multi-select field which I am planning to combine with another text field via concat, where each value is separated by a comma.  

Is there a way to create a formula column where instead of showing the result as a single line, or row, can I display them as separate (multiple depending on result) rows for each value?  

Tried to search if this question has been answered or solution provided, but was unable to find any.

Greatly appreciate any assistance on this.

Thanks,

Dubie

[David Niro · Accepted solution]

Hello @Dubie ,

If I understand correctly, you're looking for something similar to Text to Columns functionality in Excel, correct?

If I have it right, this is not currently possible.  Please feel free to share your idea here.

Best,
David