Gap in every other cell

[Gappy]

Hello

I used merged cells and found out later that I can't sort so I have un-merged them.

Now my data looks like this\/

49522 GNL Responsive Time 1
__________Completion Time 1
49715 GNL Responsive Time 1
__________Completion Time
49994 URS Responsive Time 1
__________Completion Time 1

but I want it to look like this\/

49522 GNL Responsive Time 1
49522 GNL Completion Time 1
49715 GNL Responsive Time 1
49715 GNL Completion Time
49994 URS Responsive Time 1
49994 URS Completion Time 1

It isn't a matter of copying and pasting or draging each number down holding ctrl as there are 5000 lines
of data.

Thanks for the help

[Bradleybww]

Try placing this into a module:

Please Login or Register  to view this content.

[Gappy]

I received this error when de-bugging

x(2) = "Completion" = <Subscript out of range>

[Bradleybww]

The error probably occurs on a row where there is no matching "Responsive Time". See what value xlRow has and you may need to insert a row to follow the scheme of Responsive then Completion Time as demonstrated above. In other words, every Completion Time has to have a Responsive Time in the prior row.

If that is not the case then please let me know.

[Gappy]

The data definitely follows the order Responsive then Completion the xlRow value = 0
forgive me, my coding knowledge is very low.

I have attached a screen shot to make sure we are on the same page

Untitled.png

Thanks again

[Bradleybww]

Can you attached the actual workbook you are using because xlRow should never be 0 inside of the for loop.

[Gappy]

Book1.xls

Thanks

[Gappy]

I figured out I'm a total retard ha.

In a separate column I just did this:

=a1
=a1
=a3
=a3

and dragged it down, then I copied the data and pasted into column A.

Hurr Durr why didn't I think of this earlier?