Hello,

Could you tell me what the problem is, please ?

Charaabeuh.



----------------------------------------------------------------------
"Snowy" a écrit dans le message de groupe de discussion :
...

Hello
Thanks for your reply,

I am explaning what I want in details.

I have 2 columns A & B. I dont want to do anything with column A.

In column B I have following data.

Eg. Column B
Skin conditions
Rheumatoid arthritis
Other rheumatic disorders
Congenital dislocation of hip
Maternal postnatal screening
Chemical poisoning and other contamination
Screening for:

Column C- Output
Skin conditions
Skin conditions - Rheumatoid arthritis
Skin conditions - Other rheumatic disorders
Skin conditions - Congenital dislocation of hip
Skin conditions - Maternal postnatal screening
Skin conditions - Chemical poisoning and other contamination
Skin conditions - Screening for:

Look at the world "Skin conditions" . "Skin condition" is the value
after blank cell and I want to append value after blank cell to
remaining values till next blank cell appears.

Do this until entire column ends. There are about 30K rows data out of
which 12K blank rows.