A bit more on deleting GAPS.

[sauvage]

Hello

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? Also note that whole column had formulas in it before I copied it to fresh list, so for some reason excel doest not treat A2, A3, A4 as blank, maybe I should copy it somehow differently?

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

Kind Regards,

Dim

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=617478

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).