I have a column which contains the following values
KLM, NOP, QRS, TUV
I want to count the number of times a value appears before and after a comma.
My desired result would be:
ABC, DEF 2
GHI, J 2
KLM, NOP, QRS, TUV 4
Any help would be appreciated.....