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
List expressions - AppSheet Help
If you need a more specific need, let us know
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 :
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.
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
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |