DataMystic

I need textpipe to output a file where it populates the first column NAME with the last populated first column NAME above it wherever the first column is -----.

I receive an excel file with three columns follows:
Peter Knives 2
------ Forks 3
------ Spoons 1
Mark Forks 1
John Knives 4 ...