From my screen shot below, you can see I have the column Company. In this column it has duplicated values, so I was wondering if there was a way for it to only display once using a formula in a new column? e.g. in the count column to only show The good company once.
Also would be great if this process is automated, as I am using integromat to keep insert new records.
Thank you for responding. I have tried and it works. However I also want it to show 2 records for Company. For example Good company in the screenshot has 2 records, I still want it to show all that information, but in the count or new table to visualized as Good company for 1 record and blank for the other?