Hello - I am trying to remove duplicate text values (duplicate names) from only one of my columns in power query without removing the entire row because there are values in one of the other columns that I will be adding together in power pivot. I tried just leaving the duplicate names in power query and used distinct count in my pivot table but I keep getting blanks - and my folder data source does not contain any blanks so I don’t know why this is happening. So I’ve decided to try this approach by removing the duplicate names only in the one column - but power query removes the entire row.

I would appreciate any suggestions to either of these techniques or both.  

Thank you!

Jen