transfer data into form excel 2010, multiple rows cells

I need help and I am not able to figure this out as easily as I thought.

Every day I receive a csv file of NAMES, PLACES, ADDRESSES, IDS, SPECIAL ID (ETID), ITEMS, QUANTITY, AND OTHER INANE INFORMATION. which is a list of people from places that are ordering item(s) for each ETID)

I CONVERT TO EXCEL BECAUSE I HAVE TO CLEAN THE DATA FORMATTING, AND SPLIT A COLUMN INTO 2 (LAST NAME AND ETID ARE TOGETHER).

I need to put the items into a form, one order per ETID.

I tend to receive on NAME, PLACE, ADDRESS, sending orders for multiple ETIDS.

I don't know the easiest or best way to get the info into the order form. I have designed the form in word and excel.

I am attaching files of each so this can be reviewed
I have spent a couple of days on this and I MUST come up with a way to do this ASAP.
I am not able to keep up with this doing this manually.

Anyone offering any working help is so appreciated

Thanks