Hi.

Frankly, if your dataset is as described in your OP, of all the solutions posted above, I prefer your original one!

It has two major advantages over many of the other solutions provided:

1. It works!

2 . It is extremely comprehensible.