Hello friends, I'm seeking help to convert rows information to columns. I tried crosstab query but couldn't succeed
Table
id
Field 1 ABC 1 DEF 1 GHI 2 JKL 2 MNO
I'm looking query/table something like the following.
id
column1 column2 column3 1 ABC DEF GHI 2 JKL MNO