I'll be importing Excel data into an existing table, and then breaking off part of that table into a related table with child records.
The problems is that the author created the spreadsheet rows/columns thusly:
Client A | Contract 1 | Contract 2 | Contract 3
Client B | Contract 1 | Contract 2 | Contract 3
Client C | Contract 1 | Contract 2 | Contract 3
Client D | Contract 1 | Contract 2 | Contract 3
Some of these Contract 2 and Contract 3 columns are blank -- the spreadsheet author just added more columns to the right so she could add future contracts -- but in QuickBase it makes sense for each contract to be it's own record, (rather than have one child record per client with many columns for new contract dates).
The problem is I'm not sure how to split off the table so that contract can be created as a separate child record. I don't think it can be--it seems like I'll have to copy several rows for each client and then move data for the individual contracts to their own row.
Is there another, better method?