Collapsing rows, removing blank lines between data

[conbre86]

Hi again,

I was curious to find out if there was any way to collapse data together to have it line after line. Ill draw up an example of what Im talking about. Im looking for some code to do it automatically.

Before:

example1
xxxxxxxxx
xxxxxxxxx
xxxxxxxxx
xxxxxxxxx
example2
xxxxxxxxx
xxxxxxxxx
example3

I want this:

example1
example2
example3
xxxxxxxxx
xxxxxxxxx
xxxxxxxxx

Thanks in advance for any input!

[antoka05]

You can try with this code (it deletes blank rows):

Please Login or Register  to view this content.

Regards,
Antonio

[conbre86]

Thanks Antonio! Works like a charm, thats excactly what I needed. Thanks again I really appriciate it!