merge duplicate power query

[jtomczyk]

Hallo,

I have two sources of data. I have used append queries to join them. As a result for some of them I have duplicate rows.

I would like to have only one line for each project code and to take the values from the second line if the value on the first one is null

Any idea how to do that?

[davehus · Accepted solution]

Hi @jtomczyk, You could use a group by method in Powerquey and try using Max to return the values you need. 

[v-xiaotang · Accepted solution]

Hi @jtomczyk 

after you append queries, then 

(1) replace blank cells with null

(2) fill down

(3) fill up

(4) remove duplicate rows.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[davehus · Accepted solution]

Hi @jtomczyk, You could use a group by method in Powerquey and try using Max to return the values you need. 

[jtomczyk]

After grouping I have this