hi,

I have imported data into excel. The problem is I have multiple rows that
should a number, then the number changes to something else.

For example, the data is like this:
billy 000
blue
red
yellow

tom 001
orange
banana

I need the the 000 to go down the row to everything under Billy's name and
the 001 to go to everything by tom's name and so on.

Any help?

--
stacie