Horserace Form

[Saxman]

Below is a sample of the last six finishing positions for particular horses.

What would be the best method to parse the data so that it appears in
six columns (one column for each run)?

The runs are not always numerical as you can see. There are such things
as P,F. Sometimes there are blanks (horse never ran before).

4
9_5391
9458_7
20_9
451_52
557_
360_73
983
7_1d95
32334
11226_
442735
80/830
38352
112_06
35_821
14/0_8
79_511
524174
38/8_4
74742_
82
8_2
64
0
00_2
7


Thanks in advance.

 

[Claus Busch]

Hi,

Am Sun, 15 Jun 2014 12:02:44 +0100 schrieb Saxman:

Below is a sample of the last six finishing positions for particular horses.

What would be the best method to parse the data so that it appears in
six columns (one column for each run)?

your data in column A
Then in B1:
=MID($A1,COLUMN(A1),1)
drag it 6 columns to the right and then down


Regards
Claus B.

 

[Saxman]

Hi,

Am Sun, 15 Jun 2014 12:02:44 +0100 schrieb Saxman:


your data in column A
Then in B1:
=MID($A1,COLUMN(A1),1)
drag it 6 columns to the right and then down


Regards
Claus B.

Thank you Claus.

I get the value in B1, but nothing in the other cells, dragging in the
way you describe?

 

[Saxman]

Hi,

Am Sun, 15 Jun 2014 12:02:44 +0100 schrieb Saxman:


your data in column A
Then in B1:
=MID($A1,COLUMN(A1),1)
drag it 6 columns to the right and then down


Regards
Claus B.

See previous post. Sorted. I copied the cell B1 and pasted in all the
cells.

Thanks again.

 

[Vidcapper]

See previous post. Sorted. I copied the cell B1 and pasted in all the
cells.

Thanks again.

If only someone could design a spreadsheet that was good at picking the
winners...

 

[Saxman]

If only someone could design a spreadsheet that was good at picking the
winners...

I'm still working on it. I have amassed 100000 runs over the last year
and still trying:-((

 

[Vidcapper]

On 15/06/2014 18:06, Vidcapper wrote:

I'm still working on it. I have amassed 100000 runs over the last year
and still trying:-((

Not that you'd tell anyone, if you actually succeeded...

 

[Saxman]

Not that you'd tell anyone, if you actually succeeded...

That's the worst thing one can do!