Delete empty cells within row until you hit nonempty cell

[as_sass]

Hi! I hope someone can help me with this problem - I am going nuts over it, but I am sure there is a macro that could achieve this:

I need to delete empty cells within a sheet, row by row, until I hit cells in that row that are not empty. For example:

A B C D E F
1 1 1 1 1 1
2 2 2 2 2 2
3 3 3
4 4 4 4 4 4
5 5
6 6 6 6 6 6

I want to select the first cell in column A, and then start running the macro. The macro should detect that row one should be left untouched, and proceed to row 2, than to row 3, and delete cells there, then proceed...
However, after cells have been deleted and a nonempty cell is hit, it should not delete empty cells after that. So, the above example should end up looking like this:

A B C D E F
1 1 1 1 1 1
2 2 2 2 2 2
3 3 3
4 4 4 4 4 4
5 5
6 6 6 6 6 6

This is for a non-commercial purpose - and I hope one of you could share their insight. It would save me weeks of work (I am talking tens of thousands of rows...).

Thanks so much!

as

[rylo]

Hi

I can't see any difference between the before and after example. Where is the difference???


rylo

[mikerickson]

From your description, this might work

Please Login or Register  to view this content.

[as_sass]

@ rylo (and other who were confused):

Yep, sorry, I didn't preview my post, the example pasted incorrectly. In the first example, there should have been empty cells at the beginning of rows 3 and 5.

@ mikerickson:

This works! Thanks so much for investing the time to help.

I continue to be amazed by the skills people have - but even more so that everyone here is sharing so freely.
Thanks a bunch!

as