Why would you move addr3 to addr4 (what is in addr5 - does that make a
difference) You need to state what your rule is because it doesn't make
much sense as shown. Assume 4 cells are filled, which single cell should be
blank. If 3 cells are filled, which two cells should be blank.

If addr1 and addr2 were empty and addr 3 - 5 were filled, should anything be
moved? So again, what is the rule you use.

--
Regards,
Tom Ogilvy

wrote in message
ups.com...
Hi,

I have a worksheet with 5 address columns (Addr, Addr2, Addr3, Addr4
and Addr5) with values populated. There are some rows with values in
all the cells and some with values in only few columns.

Overall this sheet has 9000 rows.

My task is to go through each row and see if the filled cells are in
order. If not for eg., addr1 has value, addr2 hasn't and then addr3 has
then I will have to move addr3 to addr4.

Finally my sheet will have rows with address details in consecutive
cells without any gaps or empty cells in between.

Can someone please tell me a quick way to achieve this.

I guess I might need to use sorting but right now I can't figure it out
how do I do this.

Thanks & Regards
Prasad