Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
52
Views
Topic starter
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!
Posted : 31/01/2020 11:44 am
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
Posted : 02/02/2020 12:06 am
