pivot table?
 

--
Learning

pivot table?
 

And the question is ???

"tracktraining" skrev i
meddelelsen ...

--
Learning

pivot table?
 

Hi All,

I was looking into a pivot table to tally up the amount of times a certain
number appears. But I realized that my column has some cells that have
multiple numbers in it that needs to be counted as well. For example:

A B
Bob 123
Mary 234, 123
Joe 456
Bob 123, 456

I need something that would give me the following result:

123 234 456
Bob 2 0 1
Mary 1 1 0
Joe 0 0 1
total 3 1 2

Can anyone please me with possibly solution?

Thanks very much