SQL Manager to transpose matching rows

[newcomer]

Hi does anyone know if it's possible to do that using SQL Manager in BO?

 

So if I have:
1 a 
1 b
1 c
2 a
2 c
2 d

I would like to get

1 a b c
2 a c d

Same with multicolumn. if I have

1 a b c
1 d
2 e f g h
2 i j

Would like to get

1 a b c d
2 e f g h i j

 

Perhaps using the PIVOT command? Does Prestashop SQL Manager allow that? If not how would one go about typing out the syntax?