I am currently importing a text file that has been normalized. I need to denormailze the file back into repeating rows...
The format of the file is
There is a header row which is valid for all subsequent rows until a new header row appears ..i.e
The A01 line needs replicating on every line until another A01 is there
The A02 - A03 line needs replicating on every line until a new A02 or A03 is present