Forum Discussion
Remove duplicate text values across multiple columns
Hello!
New Power BI user here and struggling a bit with cleaning my data... I suspect this may be an easy one for you all, so please help if you can..?
I have attached a screenshot of my data table (each letter represents a Consultant name). I need to de-duplicate the names in the table so that the name in the Lead Consultant column doesn't recur in Attendee columns 1-3.
Current dataset
So my ideal solution would look like this:
Dataset solution
Thank you so much!
QuenrilYou can go into the Query Editor and create 3 new Consultant Attendees conditional columns. I've shown one below as an example. Once all the new Consultant Attendees columns have been created, you can remove the 3 original ones and rename the new ones to what they should be.
Final result:
5 Replies
QuenrilYou can go into the Query Editor and create 3 new Consultant Attendees conditional columns. I've shown one below as an example. Once all the new Consultant Attendees columns have been created, you can remove the 3 original ones and rename the new ones to what they should be.
Final result:
