sorting a range into a single column
 

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

sorting a range into a single column
 

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

sorting a range into a single column
 

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