I would like to decompose and aggregate the multi-picklist values.

Currently the graph looks like the attached image.

[Option1] x1

[Option1, Option2, Option3] x1

I would like to aggregate as follows.

[Option1] x2

[Option2] x1

[Option3] x1

Is there any way to achieve this?