... this is what a few records look like ...

It would greatly help anyone who is trying to help you if you would also provide the exact output you expect from the example input. (You can just add an update – properly cited as such – to your post; no need for a separate node.)