Separating cell info counting in a pivot table

Hi

Can someone advise how to separate information inside a cell for counting in a pivot table?

I have attached a simplistic example showing various employees performing a task(s) on a given day.

Because of the way the task is supplied in column C, ie where more than one task is performed, is separated by a comma, the pivot table incorrectly shows the amount tasks performed by each employee as just one each.

How is it possible to count each task correctly for each employee?

Many thanks

Hi Roy

That's the way it's imported from another source that I have no access to

Never mind - I found you can accomplish this by manipulating the data in Power Query.