Forum Discussion
Solved
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...
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:
