I think it's quite simple query but i'm unfortunately lacking in SQL. I have one table with duplicates in one column (column A) and string data (that is unique) in different column (column B).
Task of my query is to return only unique values from column A (that is simple and I manage to do it with SELECT DISTINCT Column A) with one more column created in query (in my example Result) that combines data from every duplicated record data in column B. I just put to screens of table and query with requested result (it's obvious when you see it).
The best solution for me will be query creator without using SQL but I think it won't as easy;)
Table example
Query example with requested result
