Thank you Stanley for your responses and please excuse me, I should have attached a spreadsheet sample of the data and desired results.
I have attached a spreadsheet for your review.
In response to your question, I do have column names, not sure if they are useable though.
Bookmarks