Delete GAPS in columns

[sauvage]

To Whom it May Concern,

I have around 2368 rows for in each column and I have around 8 columns and what I need to do is to remove any gaps. I do not know how to attach picture here, but I can explaing it in words.

A1: 0.9
A2:
A3:
A4:
A5: -0.09
A6:
A7: 0.4

Is there a way to eliminate those gaps (A2, A3, A4, A6...) in one go?

I would much appreciate your help as it would save me loads of time.

Kind Regards,

Dim

 

[Jonmo1]

Welcome to the board.

You can highlight the column
Press CTRL + G
Cick Special
Select Blanks
Click OK
Right click any highlighted cell
Delete

Hope that helps.

 

[VoG]

Try

Sub btest()
Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

 

[jim may]

Is this a one-time situation or one which you will need to do with frequency?

 

[sauvage]

Try

Sub btest()
Columns("A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

I am not very proficient in excel, so would be grateful if you could explaing where to put this code.

Kind regards

 

[sauvage]

Is this a one-time situation or one which you will need to do with frequency?

I have 8 columns like that so all I want to do is to remove these gaps. Hope that clarifies.

 

[VoG]

Press ALT + F11, select Module from the Insert menu, paste in the code. Press ALT + Q, press ALT + F8 then double click btest

 

[sauvage]

Welcome to the board.

You can highlight the column
Press CTRL + G
Cick Special
Select Blanks
Click OK
Right click any highlighted cell
Delete

Hope that helps.

That did work. Never knew it can be so easy. Thank you very much for your help.

Thanks to every one who tried to help I appreciate this.

 

[sauvage]

Press ALT + F11, select Module from the Insert menu, paste in the code. Press ALT + Q, press ALT + F8 then double click btest

I will bear that in mind for future enquiries.

Thank you VoG

 

[Jonmo1]

Glad to help, thanks for the feedback.

That did work. Never knew it can be so easy. Thank you very much for your help.

Thanks to every one who tried to help I appreciate this.