2 Replies Latest reply on Jan 31, 2011 12:53 PM by philmodjunk

    Copy value from previous record if field in this record is blank

    loopwer5777

      Title

      Copy value from previous record if field in this record is blank

      Post

      I'm looking to find the best way to fill in a vlaue from a previous record if the value in this record is blank.

      I am importing lists of hundreds of thousands of records that look something like this:

      when the records are imported, need to fill in patriots, for tim, mark, ed.  packers for ted, mike, fred. etc...

      name           team

      bob             patriots

      tim

      mark

      ed

      harrry          packers

      ted

      mike

      fred

      al                dolphins

      freddy 

      etc...

      any suggestions?