Removing duplicates

[Hellozooey]

 

I am new to excel and power bi

i made three excel queries and I need to link them all together and manage the relationships. 

I keep getting duplicates and need help trying to figure out how to only keep the values I need not the excess.

For example IP camera the true values from excel are QTY 4 Carton 4 Pallet 1

i don't need all the excess rows 

[Greg_Deckler]

@Hellozooey Any rhyme or reason as to what designates a "correct" row versus an "incorrect" row?

[Hellozooey]

Hi greg

the value from the quantity is pulling from one excel work book 

while the value of carton and pallet is pulling from another

the value for carton and pallet for IP camera on the workbook is  4 and 1

not sure why it created duplicate rows and extra numbers