Reformat Form Responses

I am attempting to reformat a spreadsheet that I have which is data from a client list that I collected from a online form.

This is a client list for a salon where I have asked clients to provide information (i.e. mobile no, email etc.) The second part of the form asked that any client who has children (dependants) that are also clients that will have the same contact info (mobile, email) to list them out also.

The raw data I have is for the client (parent) to highlight their dependants. Individual columns, I need to be able to use the dependant columns to add an additional row for each dependant.

I have attached an example of the raw data that was received and also manually added below what my desired output would be. (This is all fictional data for the purpose of my query).

I can obviously do this manually but I have hundreds of clients to go through.

Any assistance on how I could make this happen would be greatly appreciated.

Thanks in advance.

Unfortunately that will not work. If there are three (3) members of one family.

For example Jane Smith and her kids, John and Jill Smith, I would need an individual row per person even though the contact details (phone and email) for the children would be the same as the parent, Jane Smith in this example.

Once I have the data in this format, it will then be imported back into my client software.