Fill-in missing information below
Select your ranges hit F5 Special select Blanks OK while all the
blanks cells are highlight type = and press arrow up then press Ctrl+Enter
"LuisM" wrote:
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
|