I really need your help with a tricky file I need to transform.
I have one single csv file that has lots of data records which is broken up by sub headers. There is nothing that links the data records to the sub headers apart from the order of the records. I've attached a dumb down version i am working with. However I need to tag the detail records with the sub header above them.
I am hoping that someone can help me with this!
Example Input Data:
Example Output Data:
SB,Lolly Pop,24/03/2020,Candy Box
Please sign in to leave a comment.