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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!