Spreadsheet: 847574d1698424598-data-is-by-rows-and-need-to-combine-it-into-one-row-scoring
Sheet: exported Data

Open mode | Game name | Event name | Squad name | Week number | Series number | Reservation number | [NAME] number | Customer ID | Bowler name | Gender | Game eligibility | Game number | HDCP | Scratch | Spare count | Strike count | Play position | Team name | Team HDCP | Player type | Player attribute | Team attribute | Start date | End date
Open tournament | Test Data | Singles | 1 | 0 | 1 |  | 5 | 0 | Name 1 | Male | Eligible for Center avg | 1 | 0 | 161 | 3 | 4 | 1 | Name 1 | 0 | Regular |  |  | 2023-09-03 11:47:00 | 2023-09-03 12:20:00
Open tournament | Test Data | Singles | 1 | 0 | 2 |  | 4 | 0 | Name 1 | Male | Eligible for Center avg | 2 | 0 | 216 | 5 | 6 | 1 | Name 1 | 0 | Regular |  |  | 2023-09-03 12:22:00 | 2023-09-03 12:57:00
Open tournament | Test Data | Singles | 1 | 0 | 3 |  | 1 | 0 | Name 1 | Male | Eligible for Center avg | 3 | 0 | 189 | 4 | 5 | 1 | Name 1 | 0 | Regular |  |  | 2023-09-03 12:59:00 | 2023-09-03 13:31:00
Open tournament | Test Data | Singles | 1 | 0 | 4 |  | 8 | 0 | Name 1 | Male | Eligible for Center avg | 4 | 0 | 200 | 5 | 4 | 1 | Name 1 | 0 | Regular |  |  | 2023-09-03 14:35:00 | 2023-09-03 15:06:00
Open tournament | Test Data | Singles | 1 | 0 | 5 |  | 5 | 0 | Name 1 | Male | Eligible for Center avg | 5 | 0 | 176 | 5 | 4 | 1 | Name 1 | 0 | Regular |  |  | 2023-09-03 15:11:00 | 2023-09-03 15:40:00
Open tournament | Test Data | Singles | 1 | 0 | 1 |  | 8 | 0 | Name 2 | Not specified | Eligible for Center avg | 1 | 0 | 134 | 2 | 3 | 1 | Name 2 | 0 | Regular |  |  | 2023-09-03 11:47:00 | 2023-09-03 12:21:00
Open tournament | Test Data | Singles | 1 | 0 | 2 |  | 1 | 0 | Name 2 | Not specified | Eligible for Center avg | 2 | 0 | 114 | 2 | 2 | 1 | Name 2 | 0 | Regular |  |  | 2023-09-03 12:23:00 | 2023-09-03 12:58:00
Open tournament | Test Data | Singles | 1 | 0 | 3 |  | 4 | 0 | Name 2 | Not specified | Eligible for Center avg | 3 | 0 | 146 | 2 | 3 | 1 | Name 2 | 0 | Regular |  |  | 2023-09-03 13:01:00 | 2023-09-03 13:35:00
Open tournament | Test Data | Singles | 1 | 0 | 4 |  | 5 | 0 | Name 2 | Not specified | Eligible for Center avg | 4 | 0 | 139 | 2 | 3 | 1 | Name 2 | 0 | Regular |  |  | 2023-09-03 14:35:00 | 2023-09-03 15:09:00
Open tournament | Test Data | Singles | 1 | 0 | 5 |  | 8 | 0 | Name 2 | Not specified | Eligible for Center avg | 5 | 0 | 129 | 4 | 1 | 1 | Name 2 | 0 | Regular |  |  | 2023-09-03 15:10:00 | 2023-09-03 15:44:00
Open tournament | Test Data | Singles | 1 | 0 | 1 |  | 1 | 0 | Name 3 | Female | Eligible for Center avg | 1 | 0 | 113 | 1 | 2 | 1 | Name 3 | 0 | Regular |  |  | 2023-09-03 11:47:00 | 2023-09-03 12:19:00
Open tournament | Test Data | Singles | 1 | 0 | 2 |  | 8 | 0 | Name 3 | Female | Eligible for Center avg | 2 | 0 | 191 | 6 | 4 | 1 | Name 3 | 0 | Regular |  |  | 2023-09-03 12:23:00 | 2023-09-03 12:53:00
Open tournament | Test Data | Singles | 1 | 0 | 3 |  | 5 | 0 | Name 3 | Female | Eligible for Center avg | 3 | 0 | 202 | 5 | 6 | 1 | Name 3 | 0 | Regular |  |  | 2023-09-03 12:59:00 | 2023-09-03 13:34:00
Open tournament | Test Data | Singles | 1 | 0 | 4 |  | 4 | 0 | Name 3 | Female | Eligible for Center avg | 4 | 0 | 163 | 6 | 2 | 1 | Name 3 | 0 | Regular |  |  | 2023-09-03 14:35:00 | 2023-09-03 15:06:00
Open tournament | Test Data | Singles | 1 | 0 | 5 |  | 1 | 0 | Name 3 | Female | Eligible for Center avg | 5 | 0 | 214 | 3 | 6 | 1 | Name 3 | 0 | Regular |  |  | 2023-09-03 15:11:00 | 2023-09-03 15:41:00
Open tournament | Test Data | Singles | 1 | 0 | 1 |  | 8 | 0 | Name 4 | Not specified | Eligible for Center avg | 1 | 0 | 138 | 4 | 2 | 2 | Name 4 | 0 | Regular |  |  | 2023-09-03 11:47:00 | 2023-09-03 12:21:00
Open tournament | Test Data | Singles | 1 | 0 | 2 |  | 1 | 0 | Name 4 | Not specified | Eligible for Center avg | 2 | 0 | 135 | 4 | 1 | 2 | Name 4 | 0 | Regular |  |  | 2023-09-03 12:23:00 | 2023-09-03 12:58:00
Open tournament | Test Data | Singles | 1 | 0 | 3 |  | 4 | 0 | Name 4 | Not specified | Eligible for Center avg | 3 | 0 | 177 | 3 | 4 | 2 | Name 4 | 0 | Regular |  |  | 2023-09-03 13:01:00 | 2023-09-03 13:35:00
Open tournament | Test Data | Singles | 1 | 0 | 4 |  | 5 | 0 | Name 4 | Not specified | Eligible for Center avg | 4 | 0 | 147 | 2 | 3 | 2 | Name 4 | 0 | Regular |  |  | 2023-09-03 14:35:00 | 2023-09-03 15:09:00
Open tournament | Test Data | Singles | 1 | 0 | 5 |  | 8 | 0 | Name 4 | Not specified | Eligible for Center avg | 5 | 0 | 154 | 3 | 3 | 2 | Name 4 | 0 | Regular |  |  | 2023-09-03 15:10:00 | 2023-09-03 15:44:00
Open tournament | Test Data | Singles | 1 | 0 | 1 |  | 7 | 0 | Name 5 | Not specified | Eligible for Center avg | 1 | 0 | 127 | 0 | 4 | 3 | Name 5 | 0 | Regular |  |  | 2023-09-03 11:47:00 | 2023-09-03 12:21:00
Open tournament | Test Data | Singles | 1 | 0 | 2 |  | 6 | 0 | Name 5 | Not specified | Eligible for Center avg | 2 | 0 | 122 | 2 | 2 | 3 | Name 5 | 0 | Regular |  |  | 2023-09-03 12:22:00 | 2023-09-03 12:56:00
Open tournament | Test Data | Singles | 1 | 0 | 3 |  | 3 | 0 | Name 5 | Not specified | Eligible for Center avg | 3 | 0 | 101 | 2 | 0 | 3 | Name 5 | 0 | Regular |  |  | 2023-09-03 12:59:00 | 2023-09-03 13:35:00
Open tournament | Test Data | Singles | 1 | 0 | 4 |  | 2 | 0 | Name 5 | Not specified | Eligible for Center avg | 4 | 0 | 113 | 2 | 1 | 3 | Name 5 | 0 | Regular |  |  | 2023-09-03 14:35:00 | 2023-09-03 15:03:00
Open tournament | Test Data | Singles | 1 | 0 | 5 |  | 7 | 0 | Name 5 | Not specified | Eligible for Center avg | 5 | 0 | 96 | 2 | 0 | 3 | Name 5 | 0 | Regular |  |  | 2023-09-03 15:10:00 | 2023-09-03 15:44:00
Open tournament | Test Data | Singles | 1 | 0 | 1 |  | 5 | 0 | Name 6 | Not specified | Eligible for Center avg | 1 | 0 | 103 | 2 | 0 | 2 | Name 6 | 0 | Regular |  |  | 2023-09-03 11:47:00 | 2023-09-03 12:20:00
Open tournament | Test Data | Singles | 1 | 0 | 2 |  | 4 | 0 | Name 6 | Not specified | Eligible for Center avg | 2 | 0 | 179 | 4 | 4 | 2 | Name 6 | 0 | Regular |  |  | 2023-09-03 12:22:00 | 2023-09-03 12:57:00
Open tournament | Test Data | Singles | 1 | 0 | 3 |  | 1 | 0 | Name 6 | Not specified | Eligible for Center avg | 3 | 0 | 168 | 6 | 3 | 2 | Name 6 | 0 | Regular |  |  | 2023-09-03 12:59:00 | 2023-09-03 13:31:00
Open tournament | Test Data | Singles | 1 | 0 | 4 |  | 8 | 0 | Name 6 | Not specified | Eligible for Center avg | 4 | 0 | 140 | 4 | 2 | 2 | Name 6 | 0 | Regular |  |  | 2023-09-03 14:35:00 | 2023-09-03 15:06:00
Open tournament | Test Data | Singles | 1 | 0 | 5 |  | 5 | 0 | Name 6 | Not specified | Eligible for Center avg | 5 | 0 | 199 | 2 | 6 | 2 | Name 6 | 0 | Regular |  |  | 2023-09-03 15:11:00 | 2023-09-03 15:40:00