Blank Fields with import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing a file from excel that has blank fields and I need to complete
these fields with the first completed field above the blank field so
indicator completes:-

Indicator cost qty Name
y 2:00 1 Joe
3:00 1 bill
7:00 2 ann
x 9.00 3 graham
10:00 2 Brian

becomes

Indicator cost qty Name
y 2:00 1 Joe
y 3:00 1 bill
y 7:00 2 ann
x 9.00 3 graham
x 10:00 2 Brian

thank you
 
I fill in the blanks in Excel. Insert a new column next to it - say add a
new column A. Assuming column titles in row 1 enter this in A2--
=If(B2="",A1,B2)
Autofill the rest of the column. Copy and Paste Special - Values.
 
Thanks Karl

Not quite what I am looking for.

I am automating an import of over 25 excel files a month.

need to do it automattically.

Thanks Anyway.
 
Back
Top