Excel Forum

Power Query - Merge rows into one cell

KENNETH BATILO

Member

Members

Forum Posts: 27

Member Since:
January 30, 2020

Offline

January 31, 2020 - 1:44 am

Hello,

How would you combine/merge rows into one cell?

Data is shown as below

NAME

PARENT 1

CHILD 1

PARENT 2

CHILD 1

CHILD 2

The results that I need is below

PARENT	CHILD(REN)
PARENT 1	CHILD 1

PARENT 2	CHILD 1 CHILD 2

Thanks in advance!

Mynda Treacy

Admin

Forum Posts: 4448

Member Since:
July 16, 2010

Offline

February 1, 2020 - 2:06 pm

Hi Kenneth,

Please find an example attached. Hopefully you can follow the 'Applied Steps'. There is some similarities in this post on numbering grouped data that will go part way to explaining the steps from 'Grouped Rows' onward.

Mynda

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Anders Sehlstedt, RAQUEL ACION, Chandler Davis, gogy13, Brenda Richards, Mark Luke

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 202

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Mark Luke

terimeri dooriyan

Jack Aston

AndyC

Denise Lloyd

michael serna

mashal sana

Tiffany Kang

Leah Gillmore

Sopi Yuniarti

Forum Stats:

Groups: 3

Forums: 24

Topics: 6218

Posts: 27267

Member Stats:

Guest Posters: 49

Members: 31901

Moderators: 3

Admins: 4

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

Moderators: MOTH Support, Velouria, Riny van Eekelen