I have a database table with 196000 rows (product code and related product codes) and the columns are:
product code link product
I need this data changed to:
000507 000123, 000456,
A product has one to many link product codes that I wish to display in one row instead of the above.
I've spent days trying to work this out in Access and Excel but can't do it. Would somebody please help me with this task.