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

Hi Ryu!
I had the same questions and happy to see that we are not alone!

just do the following:
Select the Row or Rows to fill
F5 Select empty cells
press = and then select cell at top of the fist selected cell
Control + enter

All cells will fill automatically!

Best,
SEOJAPAN

ryu wrote:
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

After you fill in the cells, you may want to paste the formulas as
values, so you could sort the data without problems. There are
instructions he

http://www.contextures.com/xlDataEntry02.html

SEOJAPAN wrote:
Hi Ryu!
I had the same questions and happy to see that we are not alone!

just do the following:
Select the Row or Rows to fill
F5 Select empty cells
press = and then select cell at top of the fist selected cell
Control + enter

All cells will fill automatically!

Best,
SEOJAPAN

ryu wrote:

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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html