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 ------ Spoons ...