View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin Wheeler Martin Wheeler is offline
external usenet poster
 
Posts: 57
Default 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