xl2003, win xp

Each day I get a list of races that I need to sort into a single column
starting with the earliest race. The number of races varies from day to day
So the web query looks like

1 2 3 4
Doomben(BR) 1:00 1:35 2:10 2:50
Moo(MR) 5:30 6:10 6:45 7:20
Albury(NR) 1:25 2:02 2:37 3:14

What I need is a single list that looks like

Doomben(BR) 1 1:00
Albury(NR) 1 1:25
Doomben(BR) 2 1:35
etc.

The above would be 3 cells wide

The range starts in T3 and I would like the single column to
start in J3 to J5 in width.

I am assuming it must be done in vba but if it can be done in
excel that would be great.

Any help would be greatly appreciated.
Ta,
Martin

I think i have this worked out but am having probelm turning a row of data
into a column

I am trying to do Range("A1:E1").Copy Range("B5:B9") so that I end up with a
single column. This gives me five rows of copied data .

Any help would be great.
Ta,
Martin


"Martin Wheeler" wrote in message
...
xl2003, win xp

Each day I get a list of races that I need to sort into a single column
starting with the earliest race. The number of races varies from day to
day
So the web query looks like

1 2 3
4
Doomben(BR) 1:00 1:35 2:10 2:50
Moo(MR) 5:30 6:10 6:45 7:20
Albury(NR) 1:25 2:02 2:37 3:14

What I need is a single list that looks like

Doomben(BR) 1 1:00
Albury(NR) 1 1:25
Doomben(BR) 2 1:35
etc.

The above would be 3 cells wide

The range starts in T3 and I would like the single column to
start in J3 to J5 in width.

I am assuming it must be done in vba but if it can be done in
excel that would be great.

Any help would be greatly appreciated.
Ta,
Martin

Got it all sorted


"Martin Wheeler" wrote in message
...
I think i have this worked out but am having probelm turning a row of data
into a column

I am trying to do Range("A1:E1").Copy Range("B5:B9") so that I end up with
a single column. This gives me five rows of copied data .

Any help would be great.
Ta,
Martin


"Martin Wheeler" wrote in message
...
xl2003, win xp

Each day I get a list of races that I need to sort into a single column
starting with the earliest race. The number of races varies from day to
day
So the web query looks like

1 2 3 4
Doomben(BR) 1:00 1:35 2:10 2:50
Moo(MR) 5:30 6:10 6:45 7:20
Albury(NR) 1:25 2:02 2:37 3:14

What I need is a single list that looks like

Doomben(BR) 1 1:00
Albury(NR) 1 1:25
Doomben(BR) 2 1:35
etc.

The above would be 3 cells wide

The range starts in T3 and I would like the single column to
start in J3 to J5 in width.

I am assuming it must be done in vba but if it can be done in
excel that would be great.

Any help would be greatly appreciated.
Ta,
Martin