Iterative way to do a group by each column?

[jmwagner]

I am attempting to see how many occurrences there are among certain groups. For example, how many instances were there where Group 1 and Group 5 were set as 1?

Is there a more streamlined, iterative, way of turning this:

into this, without having to do a group by for each column:

I have attached an example workflow. The goal would not to have to do a summarize tool for each column. If we were to get 100 groups, that would result in 100 summarize modules.

[kboeckholt · Accepted solution]

I added a Record ID tool and then transposed the data, joined it to itself on the RecordID, and then used a Cross Tab to create your matrix. Solution Attached.

Results:

[jmwagner]

This worked. Thank you!