Hi,

I have this data:

column A B C D

timestamp bs bp as ap
00:07.0
00:07.0 30 2402 9 2403
00:07.0
00:07.0 29 2402
00:07.0
00:07.0 8 2403
00:07.0
00:07.0 19 2402
00:07.0
00:07.0 17 2403 30 2404

What I want to do is have a macro that can combine the data so that it
moves all the values so that I have an order book that looks liek this

timestamp bs bp as ap
00:07.0 30 2402 9 2403
00:07.0 29 2402 8 2403
00:07.0 19 2402 30 2404
00:07.0 17 2403

I do not know VBA but I want to learn, so if you are kind enough to
post the code I will make the effort to dissect it to understand how
it works.

I have given a name to the columns
A is TIME
B is BS
C is BP
D is AS
E is AP

Thank you