Need to add all other employees in data base to the same row as initial employee

[Carrie4841]

The Project - Import the needed data from the Data Dump File (Sheet 2) into the mail merge file (Sheet 1)

Difficulties (I'll start with the easiest one first):
1.) (Yellow highlighted cells) If the field was blank on Sheet 2 then the field should be blank on Sheet 1 however Sheet 1, Columns I & J come over as a value zero. How do I fix this?

2.) (Orange highlighted cells) This is my actual question. The plan is to send a mail merge letter to Name #1 and in the body of the letter note that additional members of the same company are getting the same letter (Names 2 through 6). I need a formula to drop the names and titles of the additional company employees into columns N through AB. I tried creating an If Then statement but could not get it to work. The formula needs to identify the person the Name Field 1 and then enter additional employees of the same company in the corresponding fields in that row. The first row shows the results I am looking for. Please note some company may have no additional employees. Others may have as many a 6 additional employees.

I know there is a quick solution to my first question - I am just so frustrated over solving the second issue I cannot think straight for either issue. The attached spreadsheet has fake data. My Worksheet.xlsx

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.