If the empty cells have the same value in one of the other fields in your data set (e.g. records above or below have the same Campaign name), you could use the Subset formulas, in a new formula field:

SUBSET_LASTNONNULL([Package], SUBSET([Campaign]))

or

SUBSET_FIRSTNONNULL([Package], SUBSET([Campaign]))

depending on the data pattern.

If you are happy with the outcome, you can convert the formula results to static values, then delete the original field with incomplete values.

Please note there are other ways to achieve this, Regex probably being the most effective one, but the Subset formula is probably an easier option.

Hi,

I have to do this often and use a modification of the subset solution above.

Add a new field called "Row" and enter the formula CURRENTROW()

In a new field add the formula:

SUBSET_LASTNONNULL([Package], SUBSET([Row], [Row], "<="))

I've reclassified this as an Idea - a "Fill Down" operation in DataManager and in the Data > Operations menu - to avoid cumbersome workarounds.

Solution is explained here
http://forums.visokio.com/discussion/2573/missing-data-automatically-filling-in-the-blanks