How to you create a table of counts between two columns without having to list every column...

For example, this is the part of my data set I'm interested in:

EventID​

Action​

Actor
EventID1​

ActionB​

ActorX
EventID2​

ActionB​

ActorZ
EventID1​

ActionA​

ActorY
EventID2​

ActionC​

ActorZ
EventID3​

ActionA​

ActorX
EventID3​

ActionB​

ActorZ
EventID2​

ActionB​

ActorZ
EventID2​

ActionA​

ActorY​

I Want:

ActorX​

ActorY​

ActorZ
ActionA​

1​

2​

0
ActionB​

1​

0​

3
ActionC​

0​

0​

1​

The problem is I have LOTS of actors and actions--so I need a way of doing this without listing each one.

Continue reading...