Forum Discussion

jtomczyk's avatar
jtomczyk
Helper I
4 years ago
Solved

merge duplicate power query

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...
Need Help
  • davehus's avatar
    davehus
    4 years ago

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

  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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's avatar
davehus
Memorable Member
4 years ago

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

  • jtomczyk's avatar
    jtomczyk
    Helper I
    4 years ago

    After grouping I have this