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

Are the time stamps "exactly" the same time? I'm asking the question because
I'm not sure if the timestamp column is a text string or or a microsoft
serial time. You can check by selecting one of the cells and then go to
format menu to see the format of the cells.

I assume you only want to combine rows where the timestamps are the same.
If two line are different by 0.1 seconds do you want them combined? The
formating may be trucating least significant digits in the time that you are
not seeing on the worksheet. I want to make sure I'm usaing the correct
algorithmn before I write the macro.

"totalnatal" wrote:

> 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
>