They need to be split off into a separate Shippers table, then joined to the Shipments table as needed. My next step is to make a copy of the existing database and use the information from the first probe to remove columns that are not being used. It might also be worth writing a SQL query script that will look for columns that have one and only one value in them as candidates for removal. If your sample data is not representative, you might shorten the column too much. The other problem is that some SQL products do not allow you to shorten a column, but only to widen it.
Some products are picky about changing numeric data types, too.
Okay, this gets the DDL pretty well under way. Phase two will look at the embedded SQL in the programs. Changing the data types might make some problems for the host programs. Detective work can be dirty. You have a quoted string made up of integers separated by commas, and your goal is to break each integer out as a row in a table.