Get count of values from a column separated by comma

Question

I have a Google Sheet in the format given below.

Required output

a = 3
b = 3
c = 3
d = 3

Answer 1

try:

=ARRAYFORMULA(QUERY(FLATTEN(SPLIT(A1:A, ",")), 
 "select Col1,count(Col1) 
  where Col1 is not null 
  group by Col1 
  label count(Col1)''"))