report layout

[odun]

Hello all:

I have about 20K rows in excel with 2 columns, vendor name and state e.g.

Cadbury NY
Cadbury NJ
Oil AL
Cadbury AK

I would like to export the excel table to an access table.

I would like to create a report in access that will present this information in this format:

Cadbury NY, NJ, AK
Oil AL

Is this possible? Thanks for your help.