Off topic:Sql Redundant Rows Manipulation

Question

[Tom]

Hi all,

I have a table with two columns. Column 2 has some redundancies which I know how to filter but when doing it I would like to merge the text from column 1 and leave only single row. (Ideally separete the text by ";"):

Col1 Col2

1 AA 2 BB 3 AA

so that I get:

Col1 Col2

1;3 AA 2 BB

Is it possible? Thanks for help

Tom