Spreadsheet: 680510d1591061111-reformat-form-responses-client-detail-form-responses-arran-bmi-
Sheet: Form responses 1

DATA RECEIVED FROM ONLINE FORM [RAW]
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B. | Number of dependents | Dependent name | Dependent no. 1 | Dependent no. 2 | Dependent no. 3 | Dependent no. 4 | Dependent no. 5
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message | 1977-10-21 00:00:00 | 2 |  | [NAME] | Ava
[EMAIL] | Grace | Swanne | [PHONE] | Text Message | 2000-08-13 00:00:00 | 0
[EMAIL] | Sabrena | King | [PHONE] | Text Message |  | 2 |  | [NAME] | [NAME]
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message | 1981-07-17 00:00:00 | 2 |  | [NAME] | Tyler
[EMAIL] | [NAME] | Jones | [PHONE] | Text Message | 2015-12-25 00:00:00 | 0
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message | 1980-08-18 00:00:00 | 2 |  | [NAME] | Cooper
DESIRED OUTPUT |  |  |  |  |  |  |  |  |  |  |  |  | copy column N and past specail as value > format as date > drag to left and replace current DOB column.
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B. |  | Email address | First Name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B.
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message | 1977-10-21 00:00:00 | Parent | [EMAIL] | [NAME] | Smith | 411222330 | Text Message | 1977-10-21 00:00:00
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message |  | Child | [EMAIL] | [NAME] | Smith | 411222330 | Text Message | 1977-10-21 00:00:00
[EMAIL] | Ava | Smith | [PHONE] | Text Message |  | Child | [EMAIL] | Ava | Smith | 411222330 | Text Message | 1977-10-21 00:00:00
[EMAIL] | Grace | Swanne | [PHONE] | Text Message | 2000-08-13 00:00:00 |  | [EMAIL] | Grace | Swanne | 411222331 | Text Message | 2000-08-13 00:00:00
[EMAIL] | Sabrena | King | [PHONE] | Text Message |  | Parent | [EMAIL] | Sabrena | King | 411222332 | Text Message
[EMAIL] | Scarlet | King | [PHONE] | Text Message |  | Child | [EMAIL] | [NAME] | King | 411222332 | Text Message
[EMAIL] | [NAME] | King | [PHONE] | Text Message |  | Child | [EMAIL] | [NAME] | King | 411222332 | Text Message
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message | 1981-07-17 00:00:00 | Parent | [EMAIL] | [NAME] | Smith | 411222333 | [NAME] and Text Message | 1981-07-17 00:00:00
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message |  | Child | [EMAIL] | [NAME] | Smith | 411222333 | [NAME] and Text Message | 1981-07-17 00:00:00
[EMAIL] | Tyler | Smith | [PHONE] | [NAME] and Text Message |  | Child | [EMAIL] | Tyler | Smith | 411222333 | [NAME] and Text Message | 1981-07-17 00:00:00
[EMAIL] | [NAME] | Jones | [PHONE] | Text Message | 2015-12-25 00:00:00 |  | [EMAIL] | [NAME] | Jones | 411222334 | Text Message | 2015-12-25 00:00:00
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message | 1980-08-18 00:00:00 | Parent | [EMAIL] | [NAME] | Deanes | 411222335 | Text Message | 1980-08-18 00:00:00
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message |  | Child | [EMAIL] | [NAME] | Deanes | 411222335 | Text Message | 1980-08-18 00:00:00
[EMAIL] | Cooper | Deanes | [PHONE] | Text Message |  | Child | [EMAIL] | Cooper | Deanes | 411222335 | Text Message | 1980-08-18 00:00:00