View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LuisM LuisM is offline
external usenet poster
 
Posts: 1
Default Fill-in missing information below

I export a file from an accounting program to an excel csv fromat
spreadsheet, is there a way to fill-in missing (blank cells) information from
the raw above to the raws below with a formula or function?

cust1 order 123 123 Happyway USA 3hats
order 123 2shirts
order 123 2shirts
cust2 order 124 123 Bestway USA 2belts
order 124 2T-shirts

so it will look like this:

cust1 order 123 123 Happyway USA 3 hats
cust1 order 123 123 Happyway USA 2 shirts
cust1 order 123 123 Happyway USA 2 shirts
cust2 order 124 123 Bestway USA 2 belts
cust2 order 124 123 Bestway USA 5 T-shirts