Get only Distinct values

[madhuqliklondon]

Hi All,

The below expression is giving me duplicate value, Can we get only distinct values?

=Capitalize(Concat([Company Name],', '))

[sunny_talwar · Accepted solution]

Try this

=Capitalize(Concat(DISTINCT [Company Name],', '))