How to merge columns|Power Query|Excel Forum|My Online Training Hub

1. There are unique families on  each row;

2. There are two columns for a parent, FirstName  and LastName

3. There are two columns for each child in the family: FirstName1 & LastName; FirstName2 & Lastname (if this family has a 2nd child); Firstname3 & Lastname (if this family has e children)

We would like to transform it (using Power Query) to the following results

1. all data still in one row;

2. Parent Name format: FirstName LastName

3.1 Children's name: LastName, FirstName1 (if only one child in the family)

3.2 Children's name: LastName, Firstname1 & FirstName2 (If two children in the family)

3.3 Children's name: LastName, Firstname1 & FirstName2 & FirstName3 (if three children in the fmaily)

Thanks!