Hi,
all

Here is a example.
I have three columns in excel.There are some blank cells and rows.
A B C
SMH SMHP CPR


MDR



SLK
CPD DHG STG
STG



Here is how it should look after filling up the blank columns
Col A Col B Col C
SMH SMHP CPR
SMH SMHP CPR
SMH SMHP MDR
SMH SMHP MDR
SMH SMHP MDR
SMH SMHP SLK
CPD DHG STG
CPD DHG STG


Right now I am doing it manually. Is there a way I can do it by writing some
VBA code or macros

Any help would be highly appreciated?
--
Kittie