Forum

How can I combine k...
 
Notifications
Clear all

How can I combine kids' first names with Power Query if they have the same parents?

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

How can I combine kids' first names with Power Query if they have the same parents?

1. If there is only one child, then we lease it as it is.

2. There are two kids, and their first names are A and B, respectively, then we combine their first names as A & B.

3. There are three kids, and their first names are A, B, and C, respectively, then we combine their first names as A & B & C.

Only up to three kids, the most.

 

Thanks!

 

Jim

 
Posted : 24/08/2022 7:09 pm
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

Hi Jim,

I've added a PQ solution to your file. See attached.

Riny

 
Posted : 25/08/2022 12:37 am
Share: