Log In
Register
Home
January 13, 2021
Offline
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
July 16, 2010
Offline
Hi Jen,
Please upload an example file with your before and after views of your data. Please ensure the query in the file is not getting the data from an external source so that we can see the data.
Mynda
1 Guest(s)
