AnsweredAssumed Answered

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

Question asked by loopwer5777 on Jan 29, 2011
Latest reply on Jan 31, 2011 by philmodjunk

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?

Outcomes