I have a pdf file exported to CSV . it has multiple sets of data I need to extract. Basically, I want to create a data table with these headers Name, Abo#, Violation, Violation Date, Sanction , Created date
Problems I see and not sure how to get
There are multiple sets , so the first set “Abigail” will have the created date November 21,2019 (this date is from the header text). Second set have 2 names and for both, created date is December 3 2019 (date from the header), So how do I loop through and add these to the data table.