I have searched this forum and online generally but have not been able to successfully solve this for myself. I have seen it solved for others in similar situations so I know it is doable, just I am not doing it right.
I have a table that contains around 83,000 rows showing order detail information. For orders with multiple items on them, a new row is created to record the individual item information. I would like to find those duplicates and move them all to a single row. A simplistic example would be;
Order Id Product Code Qty
35007 XYZ 1
35007 ABC 1
35008 ASD 2
35009 TYU 1
35009 XYZ 2
35009 ABC 1
And I would like that to become:
35007 XYZ 1 ABC 1
35008 ASD 2
35009 TYU 1 XYZ 2 ABC 1
The spaces representing columns.
I have attached the data I am working with to this post (a sampling of rows due to the file size). If anyone can help me, it would be most appreciated!
If I failed to mention or include any pertinent data that is needed to complete this task, please let me know.
Thank you,
Karin
Bookmarks