Please, please can anyone help me, how can I move dates from ColumnA (Surname) ie various dates and date formats into the appropriate Date 2 and Date 3 columns. I would like to move these dates to form one row attached to the appropriate name, having dates all run along in the correct rows of date columns. Any help perhaps with a macro would be gratefully appreciated.
Surname First Name Number Code Date 1 Date 2 Date 3
Ross Emma 8 A08A Friday, 17 February
Tuesday, 21 February
Graham Anthony 8 A08A 14-FebLate
17-FebLate
20-FebLate
Andrews Bono 8 A08B 29-FebMorning
Burch Danny 8 A08B Monday, 30 January
Tuesday, 31 January
02-FebLate
Ranks Aretha 8 A08B Friday, 27 January
Good Monty 8 A08B Monday, 30 January
Monday, 6 February
Tuesday, 14 February
O'Connel Freddy 8 A08B 31-JanLate
Wednesday, 1 February
09-FebLate
Robinson, George 8 A08B Thursday, 23 February
Spencer Tracy 8 A08B Monday, 6 February
Monday, 20 February
Tuesday, 21 February
Adam William 9 A09A 30-JanLate
31-JanLate
13-FebLate
Thursday, 1 March
Mitchel Graham 9 A09A 27-FebLate
Fisher, Michael 9 A09A Wednesday, 29 February
Thursday, 1 March
Glasgow Mathew 9 A09A 16-FebLate
