ModelBuilder Imports with Data Manipulation

The GIS file containing the manhole data I want to import through ModelBuilder has 8 columns for pipe inverts. There is never more than 4 entering a manhole, but the GIS file scatters them through 8 columns. What is the best way to import and manipulate the data correctly into SewerCAD since it only allows for 5 inverts?