there is going to be a number of ways to slay this dragon.

Please provide a couple of data records as an example of the actual data, and if you have some, post the code that currently isn't making it happen for you...