For a database on medicinal plants i would like to combine fields from different records based on the condition that the records refer to the species.
To illustrate my question I include a screenshot showing a small portion of one of the 30 tables in my database:
What I am hoping to do, is reduce the number of records and effectively create unique identifyers in the "Scientific Name" field.
Therefore, I need a function, which allows me to combine the distinct entries in the "Use category" field, whenever the records refer to the same "Scientific name". That is, rather than having 3 records for "Scientific name = Abelmoschus moschatus Medik" I would like a single record which in the "Use category" field reads "A1, D1, S1"
Any help would be greatly appreciated.