Hi All,
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:
ID,Type,Date
SH,Fruit Box,24/03/2020
SB,Apple,24/03/2020
SB,Grapes,24/03/2020
SH,Candy Box,24/03/2020
SB,Lolly Pop,24/03/2020
SB,M&M,24/03/2020
Example Output Data:
SB,Apple,24/03/2020,Fruit Box
SB,Grapes,24/03/2020,Fruit Box
SB,Lolly Pop,24/03/2020,Candy Box
SB,M&M,24/03/2020,Candy Box