1 of 1 people found this helpful
The import should keep all the rows in order. From there you can do a loop script starting from the first record and set the vendor name with the name of the previous record unless it is not empty. Then you would set the next record to the new vendor name.
After the initial import you would script creation of vendor records in a table and then script creation of the related records in a service table.
Merged fields... I don't know how FM handles those. I would have to try it out.
Not a super instant process but faster than doing it manually and you have to script the table creation for related records anyway.