I'm just not sure how to go about this.

I meant to add that there's only one part of the process that can't be changed, and that's how the information is sent to company #2. Sadly there is nothing to be done about that. It's weird, because I'm sure that the spreadsheets are generated from company #1's database, but this is how they chose to send the info...