Reconfigure table results

I have collected some client data and need to reconfigure it so I can then import into my client database. The data I collected was from my clients and was their contact details as well as any dependants they have that are also clients but they will receive client notifications on their behalf. For example Mother and her two kids are all clients but the mother will receive notifications for the children for upcoming appointments etc.

So, I have the data as collected in its raw format and firstly I need to add row(s) below to the spreadsheet based on a value (number of dependants). If the number of dependants is 2, then 2 rows will need to be added.

Second part, to get to the desired format to enable me to import into the client database, the names of the dependants will need to populate the newly created blank rows.

I have attached an example of what I am trying to achieve.

Formulas would be preferable but if I need to use VBA, so be it.

Thanks in advance.

I have had a look at this but it would appear that some of the formula include data from Step 2 of my example. The data I have shown in step 2 and step 3 does not actually exist. I only have the raw data as shown in step 1.

There is no attachment, sorry.....

I am sorry but you have lost me, what do you mean by delete step 2 and 3. It is not working for me if I delete the data???