autofill cells without a pattern?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi!
I wonder if someone could give me a hint of how to auto fill cells or
rows when they don't have a pattern.
Every month I pull data with 3000+ entries in CSV format.
Each cell follows a row order (eg. Row1=Group, Row2=Term, Row3=SE,
etc.), however, when data on cell A1 is the same as B1, and then B1
comes empty.
Also, if data on A1 is same as B1, but data on A2 is different than B2,
then A2 and B2 have their corresponding data but B1 is still empty.
Until now, I have selected the empty cells (one by one) and performed a
"copy down" (ctrl+D) but I am getting tired of that (more than half of
the 3000+ entries come empty many times).
I cannot sort the entries or perform an auto fill, as the data doesn't
follow a pattern.

If possible, I would like to find a way to do it easily and without
having to spend too much time formatting the data.

Does someone have a hint or idea of how to fill those blank cells?
You can have a look at http://home.att.ne.jp/omega/riushi/excel.gif for
a clearer idea of this issue.

Thanks in advance!

Ryu

PS: Macros knowledge almost 0. Using Excel 2004 for Mac

.

Relevant Pages

  • RE: Why is AutoFill helpful
    ... Instead of entering data manually on a worksheet, you can use the Auto Fill ... feature to fill cells with data that follows a pattern or that is based on ... data in other cells. ...
    (microsoft.public.excel.misc)
  • Article: The Shape Of Life - Research Sheds Light On How Cells Take Shape
    ... Research Sheds Light On How Cells Take Shape ... This phenomenon of pattern formation is critical in developmental biology. ... the patterns created by proteins called microtubules. ... Then these bundles buckle. ...
    (sci.bio.evolution)
  • Re: sea urchin genome
    ... Neural crest cells diversify under the right developmental conditions to ... Genes facilitate that process, ... I am not really sure what you mean by the "modularity" you rail ... from the branching pattern of specific individual cells to ...
    (talk.origins)
  • RE: "auto fill" Look Up table
    ... I don't think you need autofill. ... pattern of at least two cells and want to repeat the pattern. ... select two cells and then copy the pattern down the worksheet. ... Then on the worksheet select cells A1 and A2 and pull down the worksheet ...
    (microsoft.public.excel.programming)
  • Re: Excel: How do I auto expand Cells to show all the wrapped text
    ... Have auto row height set, word wrap, ... etc. Have not maxed out in the # characters/cell. ... and wrap text, ... Some of the cells wrap and auto height the rows to show all of the text ...
    (microsoft.public.excel.worksheet.functions)