Combining multiple columns into single column based one another field

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subscript out of range error given by Report Wizard 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Populate cells based on key cell 4
Display list from one colum if value in other column matches x 7
Problem editing a query based on another query and table 3
copy cell from one row based on cell from another row 2
Send Email Based on Spreadsheet Criteria 8
Help writing a macro 3

Top