Excel formulas for mail merge

Job ID: 36179983

Budget: $30 – $250 AUD

I have sheets of data and want to extract and combine names and addresses for a mail merge. There are several name combinations and it is not a completely straightforward job.
See the attached file for desired name combination outcomes.
I want you to write formulas to achieve these name combinations.
If this job is challenging for you, please don't apply , as the jobs after this one are only going to get more challenging.

I would ideally like to establish a longer term business relationship with a more advanced programmer who can also assist with more complex project feasibility spreadsheets/software design.
Related categories: Excel Google Sheets