Forum

How to merge column...
 
Notifications
Clear all

How to merge columns

3 Posts
2 Users
0 Reactions
104 Views
(@jycccwjc)
Posts: 64
Estimable Member
Topic starter
 

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!

 
Posted : 20/02/2019 10:40 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Jim,

Please see attached.

Mynda

 
Posted : 20/02/2019 11:38 pm
(@jycccwjc)
Posts: 64
Estimable Member
Topic starter
 

Mynda,

Many, many thanks! You solved my problem.

Jim

 
Posted : 21/02/2019 11:30 am
Share: