Delete empty cells bit shift to the right

[soyti]

I am looking for a way to delete cells (usually blank cells), and after deleting, the other cells will shift right. My main purpose is to align all data to the right because I am data cleaning.

We all know that deleting cells only gives 2 options, shift left or shift right.

Is this possible without vba? If VBA is necessary, can you share the code?

 

[rowebca]

Well, first of all I guess the picture is the desired result, but you're moving cells to right only if in the column H is empty or another criteria? Can you clarify this?

Regards,
GB

 

[soyti]

I want them to move to the right after all empty cells are deleted. Meaning all cells with data, after deleting all blank cells, will be beside each other with no blank cells in between any of them.

What I do is, I select a range, then select only blank cells using Control G. Then right click and delete cells, BUT I want to shift right. It's like, he opposite of delete cells - shift left.

 

[Joe4]

I still find your explanation a big confusing.
Can you show us an example, with the following 2 images?
1. What your data looks like to start.
2. What your desired output should look like.

I thought maybe that is what you were trying to show in your initial picture, but the pictures do not seem to correspond with your description.

 

[Peter_SSs]

Welcome to the MrExcel board!

We all know that deleting cells only gives 2 options, shift left or shift right.

I have to disagree, though I assume you just made a typo when writing the statement.

I do agree with Joe's request though

Can you show us an example, with the following 2 images?
1. What your data looks like to start.
2. What your desired output should look like.