Conslidation Query

[Irish_Griffin]

Hi everyone,
Hopefully this one is easy, failed on searching because I don't think I know the terminology:

I need a query the takes this example table:

Field1 | Field2
A | 2
B | X
A | 3
A | X
C | 1
C | 2

And the query outputs:

Field1 | Field2
A | 2 , 3, X
C | 1, 2
B | X

Thanks,
Aaron

 

[SOS]

Check this out.

 

[Irish_Griffin]

Check this out.

Great!! Thanks!