I would really like to get this working . I have a powerquery where i am grouping by different things and getting the results in the worksheet. I need to know how to power query to match up one more time with anyone that has two id's and the same pay rates. It needs to combine them into one.
so in the example you will have to combine the user 3682
it should combine him as show on the results tab
it will combine rows b when it is two jobs titles or multiple . There could be someone working a couple more
it would keep the same employee number , last name , first name , company and pay rate
you will need to sum colums g through N
this is only done if the employee number and pay rate are the same. If they are then the above needs to work. if it is not then we leave the cell alone.
if you can not combine job code then you can just keep 1 or the other . I would like both so when i compare i know what got combined.
I been trying ever group by i can think of. I get one part correct and it messes up the people with pay rates that are different. I just need things combined when payrates and employee number are the same.
hopefully this makes sense.
if this can not be done by powerquery then let me know. If it needs to be vba script or maco i am okay with that too. I just rather have it all automated.
thank you in advanced. This is driving me nuts. I will not tell you how long i have been banging my head on the wall. The data that was sent over was not good at all. This is just the last part before i can do some real magic. Who knows I might need help with that. I am learning though with every post on here .
Bookmarks