How to use &nbsp for UNIQUE() function of a list of cell values ?

[kvngo94]

Hello Friends, 

If I have a column as below : 

A

A

B

B

C

Then I use UNIQUE([Column[), result will be like :  A,B,C

But could you advise me how to get the result as below with each value got down the line : 

A

B

C

[SkrOYC]

List expressions - AppSheet Help

If you need a more specific need, let us know

[kvngo94]

Hi SkrOYC, 

I put in the template (google doc) this

It results in : 

Could you advise how to get the result as below with each item in 1 line : 

[MultiTech]

You're looking for the substitute function.

I've literally got a sample app that does exactly what you're looking for, explaining everything you need to do.

I grab a link for you, but my internet is down, so I'm doing all of this on my mobile phone - I apologize for the brevity.

[SkrOYC]

In case he wants to take a list and put it on a way that each item is on it's own line, yep. I barely understanded what he wanted 😅 but you nailed it