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