This doesn't sound like it would be too hard to do at all, but I really can't read your table: could you resend the table and the desired intermediate and final steps but format them more legibly?
Something like: A B 2 545 NA8 784 NULL 3 269 NULL assuming that is where you are starting. I'm not entirely sure what you expect to happen moving from one table to another, because the numbers change which seems that you are hoping for more than a short and fill missing values....(545 becomes 543? 264 becomes 265 and 268?) Again, it shouldn't be hard, just provide a more legible request and you'll be on your way. Michael Weylandt On Sat, Jul 30, 2011 at 1:25 AM, Jeffrey Joh <johjeff...@hotmail.com> wrote: > > > > > 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]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
