How to report and analyze a multi-select field entries distinctly ?

How to report and analyze a multi-select field entries distinctly ?

As many of CRM users

I have many multi-select fields that allows me to choose more than one chose in one cell for a specific filed Like:

Field A
- A;BC
- A;C
-B;C

But when reporting the field it will handle each cell as a "String" not multiple entries which as one users says:
"Why does multi-select even exist if its not reportable?"

I Sow this issue repeated in many ways in the community without reaching a proper solution to sort it out


I trust that there is an answer for this requirement somewhere

Regards
Mohammed