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