Merging A list to show unique value/identifier
I am wondering if anyone could share some ideas on this.
I have a list of available products. Some of these products are repetitive in the list. For example
I would like to show a list of AVAILABLE products in the dashboard, but without the duplicated products. So ideally, it should be showing in the dashboard as below;
Since this product list is using an API from another source, it keeps throwing all product names so I will always get a duplicated list whenever it is being updated.
Question - is report the best solution to combine this? Does anyone have any experience with formulas or other features that you could recommend (that can b used frequently as new products will be updated from time to time?)