VBA code for aligning excel file converted from text file.

Hi Friends,

I have converted text file to excel file and having some field alignment problem. Here are they:

1) Data are from column A to column AO.
2) Data available in all fields of A.
3) Check all data from C to AO in all rows. If all fields are blank(ignore A & B), delete entire row.
4) Check value in field O, If empty, check next row field D. IF empty, check until field D has value.
5) Cut the data from field D to end of row (say upto AZ)and paste it in field O of point # 4.
(i.e., check values of O1,O2,O3..... If O15 is empty then check D16 and if it has value, cut D16:AZ16 and paste it in O15 and delete row16. Check until nth row)
6) continue until end of last row.(may be upto 10,000 rows)

Could anyone provide me a VBA code for the above steps?

Thanks in advance.

Thank you for your reply Mr. Alansidman,

I have attached the sample file. Is it okay?

Thanks once again.