Moving Rows within Excel

Closed
Mrs Shiel - Mar 14, 2012 at 12:05 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 14, 2012 at 12:48 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Mar 14, 2012 at 12:48 AM
difficult to copy it on excel sheet and manipulate
upload sheet (file) in speedyshare.com and post web page address for downloading
0