Can be done, but only way I know how would be with VB to process the file
during input instead of using the default delimited file importer.
Think about going ahead and getting the data into a single sheet then use
Data | Filter | AutoFilter
to identify the various groups. While you have a group in view (with others
hidden) you can copy those rows to other sheets and even delete (just) those
rows, then choose a different group, repeat as required.
If you've got an incredibly large number of sales groups to deal with and/or
this is going to be a frequently performed operation, you may want to
consider recording a macro as you do it and then modifying the macro to add
new data imported to the bottom of existing data for each sales group. Or
just write a macro that does all of the data movement for you.
