I have a spreadsheet of names and addresses. The problem is I have one row that contains address, city, ST, zip and multiple names. I would like to count the number of NAME fields and insert that many rows. The ultimate goal is it insert the rows, copy all the address fields into the rows below it and copy each name so that there is a separate row for each name and a complete address for each name.

Any help would be appreciated.