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
|