I am a new bie and currently working through my training and I am trying to clean a data set specifically the Government Cyber Breaches Data set in the Time Intelligence - Highlighting Trends Challenge. I have two columns that have multiple entries in the rows the columns are (Location of Breached Information) and (Type of Breach).
I don’t know how to clean these columns so they have only single entries in each row please I would appreciate help and guidance on how to proceed with this step.
I will suggest you use UI option available in power bi for transformation as per my understanding that will solve your problem.
In case any further discussion ping here
Due to the length by which this post has been active, we are tagging it as Solved.
Thanks to the contributors of this post.
For further questions related to this post, please make a new thread. Please feel free to reopen this thread if anyone would like to answer the pending inquiry above.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done.