search for: null5

Displaying 1 result from an estimated 1 matches for "null5".

Did you mean: null
Replacing null values
2011 Jul 30
4
Replacing null values
I would like to reorder a two-column table by column A, then fill column B with the values above it. For example: Original:A B2 545 NA8 784 NULL3 269 NULL First sort by column A:A B2 543 264 NULL5 NA8 789 NULL Then replace null/na values in column B with the value above it:A B2 543 264 265 268 789 78 What is the best way to do this?Jeff [[alternative HTML version deleted]]