Forum Discussion
Merge Rows with Same ID into One and Keep values from others. POWERQUERY
Im trying to transform a table that will merge multiple rows into one but keep the values from the other columns. I don't know if I have to use transpose, pivot or unpivot. For a better understanding...
Sample Data:
| ID | Sales | Profit | Serial No | Brand |
| 4 | 100 | |||
| 5 | 500 | |||
| 4 | 50 | |||
| 4 | ABC | |||
| 5 | 24 | |||
| 5 | 25 | |||
| 5 | XYZ | |||
| 4 | 25 |
1. In Powerquery, select transform, then select group by, then enter the values like below,
2. Now, you will get the desire output like below.
Hope, this is your expectation. Thanks!