Power Query - Uniting rows based on column values.

[JoaoPereira]

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

[Vera_33 · Accepted solution]

Hi @JoaoPereira 

Based on your sample, you can do Group By