I want to display only unique countries in view. For example, my data looks like this:
Country | State | Brand
--------------------------------
USA | Texas | Ford
USA | California | Apple
UK | London | Rolls-Royce
In my view, I want to display only one row per country, avoiding duplicate country entries. The expected output should be:
Country | State | Brand
----------------------------
USA | Texas | Ford
UK | London | Rolls-Royce
I would appreciate any guidance on how to implement.
Please login or Register to submit your answer