Forum Discussion
Power Query - Uniting rows based on column values.
Hello Power BI community. I hope you are all doing fine.
I am here today to ask for help regarding the possibility of uniting rows based on a column value. Below is an example table for this purpose:
| Name | Age | X-Value | Y-Value |
| John | 20 | 30 | null |
| John | 20 | null | 15 |
| Mary | 30 | 50 | null |
| Mary | 30 | null | 35 |
| Eric | 40 | 40 | null |
| Eric | 40 | null | 25 |
In this example table, I have two rows for each person, with identical names and ages. They are the same person, just written twice due to server errors. I would like to be able to join the x-values and y-values based on whether the names are identical. This assumes of course no two people have the same name, which they won't have. Here is what my final table should look like:
| Name | Age | X-Value | Y-Value |
| John | 20 | 30 | 15 |
| Mary | 30 | 50 | 35 |
| Eric | 40 | 40 | 25 |
The base table is automatically exported from a server and will always come in this exact same format - Name, Age, X-Value, Y-Value. Please let me know if there are any steps in Power Query where I am able to automatically join x-value and y-value rows as long as the names are the same.
Best,
Joao
