Moving dates from one row to the end of above

Wester Ross - Mar 12, 2012 at 05:24 PM
 Blocked Profile - Mar 13, 2012 at 02:43 AM

How can I move dates from ColumnA (Surname) ie various dates and date formats into the appropriate Date 2 and Date 3 columns. I want 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.

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
Andrews Bono 8 A08B 29-FebMorning
Burch Danny 8 A08B Monday, 30 January
Tuesday, 31 January
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
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
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

1 reply

Blocked Profile
Mar 13, 2012 at 02:43 AM

Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.