Columns with multiple enteries

[Anonymous]

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) in order to create a logical dashboard with slicers for each headers (Task, Project, Work Type, Team Responsible)?

Task	Project	Work Type	Team Responsible
Task 1	Project A	Management	Team A, Team B
Task 2	Project A	Research, Management	Team A
Task 3	Project B	Planning	Team C
Task 4	Project C	Planning, Management	Team A, Team B, Team C
Task 5	Project C	Research	Team B

[truptis]

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.

[Anonymous]

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?