Forum Discussion
Columns with multiple enteries
Hello there, I have data in the table in the below format. There can be multiple entities involved in a single task. What could be the best way to clean up this data (or use table relationships) ...
Hi Anonymous ,
Firstly, split the columns which has multiple values. You can do this by goint to transform data -> Split Column
after that you can use slicers for each column.
Anonymous -> if this helps you, then please hit the thumbs up & mark it as a solution. Thanks.
I think, Split into Rows will be better because splitting into columns will create many columns which will be a problem while plotting them into visuals. Any thoughts?