Recursive Frequency Matrix

[volfiedParticipant Started: 8Replies: 14Total: 22]

How would you go about creating a frequency matrix from a single column, matched on a unique identifier?

Data                                  Result

ID  Value             D  C  B  A
1   A              A  0  2  1  2
1   C              B  1  1  2  1
2   A              C  0  3  1  2
2   B              D  1  0  1  0
2   C
3   C
4   D
4   B

I’m hitting a wall on this. It would need a duplicate of the Value column, I gather, but I can’t figure out how to get the context of the measure to come out right.

Thanks in advance for any help you can offer.

[Author]

Posts