Moving dates from one row to the end of above

[Closed]
Report
-
 Blocked Profile -
Hello,

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
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


Greetings,

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.)

https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

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

We trust that you understand.

Moderator