Hi, I am trying to do something new to me, I am trying to merge multiple rows in Power query, any assistance would be greatly appreciated. Below is an example of the table I am working with, and the end result I am looking for. Basically, I need all rows in Description column to merge to one row.
example
QTY | Description | Rate | Amount |
15 | security services | 12 | 180 |
for Clocks | |||
Total | 180 |
Desired result
QTY | Description | Rate | Amount |
15 | security services for Clocks | 12 | 180 |
Thanks
ZF
mmbr1606
9
Super User 2025 Season 1
stampcoin
7
SD-13050734-0
6