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

Report
All responses (
Answers (