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!
Hi Jim,
Please see attached.
Mynda
Mynda,
Many, many thanks! You solved my problem.
Jim