Moving Rows within Excel

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

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

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
difficult to copy it on excel sheet and manipulate
upload sheet (file) in speedyshare.com and post web page address for downloading