Spreadsheet: 764244d1642658934-help-needed-with-splitting-data-into-separate-columns-example
Sheet: RAW DATA

Submission ID | User ID | Submission Date and Time | First Name | Last Name | [NAME] | Netball Club/Team Name | Coach | Coach Mobile | Coach [NAME] | Team Name | Players | President [NAME]
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club | one | test |  | test team 1 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club 2 | two | test |  | test team 2 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club 3 | three | test |  | test team 3 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club 4 | four | test |  | test team 4 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club | five | test |  | test team 5 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club | six | test |  | test team 6 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club | seven | test |  | test team 7 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club | [NAME] | test |  | test team 8 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club | [NAME] | test |  | test team 9 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club | [NAME] | test |  | test team 10 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club | [NAME] | test |  | test team 11 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile:
1 | 2 |  | [NAME] | bloggs | [EMAIL] | test club | [NAME] | test |  | test team 12 | 1:Name:first name last name  1:Date of Birth:28/11/2002  1:Mobile:04444444  2:Name:first name last name  2:Date of Birth:13/01/2005  2:Mobile:04444444  3:Name:first name last name  3:Date of Birth:17/11/2005  3:Mobile:04444444  4:Name:first name last name  4:Date of Birth:10/08/2005  4:Mobile:04444444  5:Name:first name last name  5:Date of Birth:22/07/2005  5:Mobile:04444444  6:Name:first name last name  6:Date of Birth:03/03/2004  6:Mobile:04444444  7:Name:first name last name  7:Date of Birth:01/08/2004  7:Mobile:04444444  8:Name:first name last name  8:Date of Birth:23/12/2005  8:Mobile:04444444  9:Name:  9:Date of Birth:  9:Mobile:  10:Name:  10:Date of Birth:  10:Mobile:  11:Name:  11:Date of Birth:  11:Mobile:  12:Name:  12:Date of Birth:  12:Mobile: