Combining multiple columns into single column based one another field

  • Thread starter Thread starter aine_canby
  • Start date Start date
A

aine_canby

What query would I need to convert this two field table -

Test1 121
Test2 121
Test2 244
Test3 121
Test4 121
Test4 224
Test4 566
Test5 566
Test5 566

to this one -

Test1 121
Test2 121, 244
Test3 121
Test4 121, 224, 566
Test5 566
Test5 566

Thanks in advance,

Aine
 
Back
Top