I agree with Norie, that rather than working with the data in the format that it comes in with I would prepare Tables to proper Relational database design.
Then use the imported data table as Temporary data, distribute it to the prepared tables and then delete the records.