What would be the most sensible way to proceed with this?

Just do it :) any way you know how :)

FWIW, you should already know two ways to handle it :) reformatting tab delimited file, Combining 3 files