Excel Forum

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

Jim Chen

Member

Members

Power BI

Forum Posts: 54

Member Since:
February 20, 2019

Offline

August 24, 2022 - 9:09 am

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

Riny van Eekelen

Örnsköldsvik, Sweden

Moderator

Members

Trusted Members

Moderators

Power BI

Forum Posts: 442

Member Since:
January 31, 2022

Offline

August 24, 2022 - 2:37 pm

Hi Jim,

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

Riny

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Kim Knox, Nada Perovic, techno tux, Othman AL MUTAIRI

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 205

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Othman AL MUTAIRI

Misael Gutierrez Sr.

Attif Ihsan

Kieran Fee

Murat Hasanoglu

Brett Dryland

Saeed Aldousari

Bhuwan Devkota

Kathryn Patton

Maria Conatser

Forum Stats:

Groups: 3

Forums: 24

Topics: 6222

Posts: 27293

Member Stats:

Guest Posters: 49

Members: 31916

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen