Create new column from specific row entries in old column

[mazacini]

How can I take this data

13/08/2012	14.15
16/08/2012	8.18
17/08/2012	12.22
John Doe	34.55
14/08/2012	8.47
15/08/2012	4.58
16/08/2012	9.39
17/08/2012	12.04
18/08/2012	10.19
19/08/2012	0.01
AN Other	45.48
15/08/2012	5.3
15/08/2012	9.16
16/08/2012	10.08
17/08/2012	11.15
18/08/2012	12.15
19/08/2012
Mr X	48.24

and make it load like this?:

John Doe	13/08/2012	14.15
John Doe	16/08/2012	8.18
John Doe	17/08/2012	12.22
AN Other	14/08/2012	8.47
AN Other	15/08/2012	4.58
AN Other	16/08/2012	9.39
AN Other	17/08/2012	12.04
AN Other	18/08/2012	10.19
AN Other	19/08/2012	0.01
Mr X	15/08/2012	5.3
Mr X	15/08/2012	9.16
Mr X	16/08/2012	10.08
Mr X	17/08/2012	11.15
Mr X	18/08/2012	12.15
Mr X	19/08/2012

[manojkvrajan]

Mazacini, What is the association between John Doe, AN Other and Mr. X with the Date column?

[mazacini]

Hi Manoj

In the first table, the first 3 entries are values (hh:mm) per day for John Doe,which are then totalled against his name in Line 4.

Lines 5 to 10 are the entries for An Other, which are then totalled on Line 11.

The table is an extract from a much larger table, where a full years data might appear for each name.

I hope I have explaned it properly.

Joe