I have a data table in SQL, Access and I have also exported it to Excel. It has two columns "item_no" and "alt_item_no".
Here is an example of the current table:
I need to reformat the data so it displays like this:
alt_item_no item_no_1 item_no_2 item_no_3 item_no_4 item_no_5 item_no_6
A002-0.0 FBA03HA450AB-00 FBA03HA450KE-00 FBA03HA450NA-00 FBA03HA450UB-00
A003-0.0 FBA04HA450AB-00 FBA04HA450BA-00 FBA04HA450BB-00 FBA04HA450KE-00 FBA04HA450NA-00 FBA04HA450VB-00
A004-0.0 FBA04HA600AB-00 FBA04HA600KE-00 FBA04HA600NA-00 FBA04HA600VB-00
Seems like it should be simple, but I've spent a day looking at SQL queries and pivot tables and cannot find a solution. I would do this by hand, but the table has 200,000 rows. Doesn't matter if I use SQL, Access, or Excel as long as the final table can be exported to a CSV for import
Each alt_item_no can have anywhere from one to twenty or more items associated with it. This is for an import into a new inventory system that handles alternate items differently than my current system.
Any help would be appreciated.