Hi All: I have data that is like this: ColumnA ColumnB @1email 1232;0829 @2email 1232;0829;0938 @1email 0938;48294;2938 @4email 0829;0938;0384 my goal is to get this: Basically the count of column B each number before the ; - how many times they showed up ColumnA ColumnB 1232 2 0829 3 0938 3 48294 1 2938 1 0384 1
... View more
