Spreadsheet: 845850d1697183944-transpose-and-remove-dups-excel-forum-example_updated
Sheet: Sheet1

BEFORE
ASSIGNMENT_ID | ASSIGNMENT_DATE | ASSIGNMENT_END_DATE | PROGRAM_YEAR | HOURS_TYPE_ID | Q1 | Q2 | Q3 | Q4
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | 225 | 6 | 2 |  | 0
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | 226 | 0 | 0 |  | 0
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | 227 | 30 | 72 |  | 322
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | 228 | 198 | 72 |  | 0
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | 229 | 0 | 0 |  | 0
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | 230 | 0 | 0 |  | 0
10913214 | 2023-02-16 00:00:00 | 2023-05-06 00:00:00 | 2022 | 228 |  |  | 36 | 25
10921235 | 2023-06-01 00:00:00 |  | 2022 | 229 |  |  |  | 20
10912901 | 2023-02-01 00:00:00 | 2023-09-11 00:00:00 | 2022 | 228 |  |  | 154 | 246
10913100 | 2023-02-06 00:00:00 |  | 2022 | 228 |  |  | 189 | 65
10923744 | 2023-06-20 00:00:00 |  | 2022 | 228 |  |  |  | 14
10908943 | 2022-12-15 00:00:00 |  | 2022 | 228 |  |  | 181 | 230
10894293 | 2022-04-19 00:00:00 | 2022-11-11 00:00:00 | 2022
AFTER
ASSIGNMENT_ID | ASSIGNMENT_DATE | ASSIGNMENT_END_DATE | PROGRAM_YEAR | QUARTER | 225 | 226 | 227 | 228 | 229 | 230 |  |  | ASSIGNMENT_DATE | ASSIGNMENT_END_DATE | PROGRAM_YEAR | Quarter | 225 | 226 | 227 | 228 | 229 | 230
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | Q1 | 6 | 0 | 30 | 198 | 0 | 0 |  | 9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | Q1 | 6 | 0 | 30 | 198 | 0 | 0
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | Q2 | 2 | 0 | 72 | 72 | 0 | 0 |  | 9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | Q2 | 2 | 0 | 72 | 72 | 0 | 0
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | Q3 |  |  |  |  |  |  |  | 9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | Q3 | 0 | 0 | 0 | 0 | 0 | 0
9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | Q4 | 0 | 0 | 322 | 0 | 0 | 0 |  | 9946941 | 2022-07-06 00:00:00 | 2022-12-04 00:00:00 | 2022 | Q4 | 0 | 0 | 322 | 0 | 0 | 0
10913214 | 2023-02-16 00:00:00 | 2023-05-06 00:00:00 | 2022 | Q1 |  |  |  |  |  |  |  | 10913214 | 2023-02-16 00:00:00 | 2023-05-06 00:00:00 | 2022 | Q1 | 0 | 0 | 0 | 0 | 0 | 0
10913214 | 2023-02-16 00:00:00 | 2023-05-06 00:00:00 | 2022 | Q2 |  |  |  |  |  |  |  | 10913214 | 2023-02-16 00:00:00 | 2023-05-06 00:00:00 | 2022 | Q2 | 0 | 0 | 0 | 0 | 0 | 0
10913214 | 2023-02-16 00:00:00 | 2023-05-06 00:00:00 | 2022 | Q3 |  |  |  | 36 |  |  |  | 10913214 | 2023-02-16 00:00:00 | 2023-05-06 00:00:00 | 2022 | Q3 | 0 | 0 | 0 | 36 | 0 | 0
10913214 | 2023-02-16 00:00:00 | 2023-05-06 00:00:00 | 2022 | Q4 |  |  |  | 25 |  |  |  | 10913214 | 2023-02-16 00:00:00 | 2023-05-06 00:00:00 | 2022 | Q4 | 0 | 0 | 0 | 25 | 0 | 0
10921235 | 2023-06-01 00:00:00 |  | 2022 | Q1 |  |  |  |  |  |  |  | 10921235 | 2023-06-01 00:00:00 |  | 2022 | Q1 | 0 | 0 | 0 | 0 | 0 | 0
10921235 | 2023-06-01 00:00:00 |  | 2022 | Q2 |  |  |  |  |  |  |  | 10921235 | 2023-06-01 00:00:00 |  | 2022 | Q2 | 0 | 0 | 0 | 0 | 0 | 0
10921235 | 2023-06-01 00:00:00 |  | 2022 | Q3 |  |  |  |  |  |  |  | 10921235 | 2023-06-01 00:00:00 |  | 2022 | Q3 | 0 | 0 | 0 | 0 | 0 | 0
10921235 | 2023-06-01 00:00:00 |  | 2022 | Q4 |  |  |  |  | 20 |  |  | 10921235 | 2023-06-01 00:00:00 |  | 2022 | Q4 | 0 | 0 | 0 | 0 | 20 | 0
10912901 | 2023-02-01 00:00:00 | 2023-09-11 00:00:00 | 2022 | Q1 |  |  |  |  |  |  |  | 10912901 | 2023-02-01 00:00:00 | 2023-09-11 00:00:00 | 2022 | Q1 | 0 | 0 | 0 | 0 | 0 | 0
10912901 | 2023-02-01 00:00:00 | 2023-09-11 00:00:00 | 2022 | Q2 |  |  |  |  |  |  |  | 10912901 | 2023-02-01 00:00:00 | 2023-09-11 00:00:00 | 2022 | Q2 | 0 | 0 | 0 | 0 | 0 | 0
10912901 | 2023-02-01 00:00:00 | 2023-09-11 00:00:00 | 2022 | Q3 |  |  |  | 154 |  |  |  | 10912901 | 2023-02-01 00:00:00 | 2023-09-11 00:00:00 | 2022 | Q3 | 0 | 0 | 0 | 154 | 0 | 0
10912901 | 2023-02-01 00:00:00 | 2023-09-11 00:00:00 | 2022 | Q4 |  |  |  | 246 |  |  |  | 10912901 | 2023-02-01 00:00:00 | 2023-09-11 00:00:00 | 2022 | Q4 | 0 | 0 | 0 | 246 | 0 | 0
10913100 | 2023-02-06 00:00:00 |  | 2022 | Q1 |  |  |  |  |  |  |  | 10913100 | 2023-02-06 00:00:00 |  | 2022 | Q1 | 0 | 0 | 0 | 0 | 0 | 0
10913100 | 2023-02-06 00:00:00 |  | 2022 | Q2 |  |  |  |  |  |  |  | 10913100 | 2023-02-06 00:00:00 |  | 2022 | Q2 | 0 | 0 | 0 | 0 | 0 | 0
10913100 | 2023-02-06 00:00:00 |  | 2022 | Q3 |  |  |  | 189 |  |  |  | 10913100 | 2023-02-06 00:00:00 |  | 2022 | Q3 | 0 | 0 | 0 | 189 | 0 | 0
10913100 | 2023-02-06 00:00:00 |  | 2022 | Q4 |  |  |  | 65 |  |  |  | 10913100 | 2023-02-06 00:00:00 |  | 2022 | Q4 | 0 | 0 | 0 | 65 | 0 | 0
10923744 | 2023-06-20 00:00:00 |  | 2022 | Q1 |  |  |  |  |  |  |  | 10923744 | 2023-06-20 00:00:00 |  | 2022 | Q1 | 0 | 0 | 0 | 0 | 0 | 0
10923744 | 2023-06-20 00:00:00 |  | 2022 | Q2 |  |  |  |  |  |  |  | 10923744 | 2023-06-20 00:00:00 |  | 2022 | Q2 | 0 | 0 | 0 | 0 | 0 | 0
10923744 | 2023-06-20 00:00:00 |  | 2022 | Q3 |  |  |  |  |  |  |  | 10923744 | 2023-06-20 00:00:00 |  | 2022 | Q3 | 0 | 0 | 0 | 0 | 0 | 0
10923744 | 2023-06-20 00:00:00 |  | 2022 | Q4 |  |  |  | 14 |  |  |  | 10923744 | 2023-06-20 00:00:00 |  | 2022 | Q4 | 0 | 0 | 0 | 14 | 0 | 0
10908943 | 2022-12-15 00:00:00 |  | 2022 | Q1 |  |  |  |  |  |  |  | 10908943 | 2022-12-15 00:00:00 |  | 2022 | Q1 | 0 | 0 | 0 | 0 | 0 | 0
10908943 | 2022-12-15 00:00:00 |  | 2022 | Q2 |  |  |  |  |  |  |  | 10908943 | 2022-12-15 00:00:00 |  | 2022 | Q2 | 0 | 0 | 0 | 0 | 0 | 0
10908943 | 2022-12-15 00:00:00 |  | 2022 | Q3 |  |  |  |  |  |  |  | 10908943 | 2022-12-15 00:00:00 |  | 2022 | Q3 | 0 | 0 | 0 | 181 | 0 | 0
10908943 | 2022-12-15 00:00:00 |  | 2022 | Q4 |  |  |  |  |  |  |  | 10908943 | 2022-12-15 00:00:00 |  | 2022 | Q4 | 0 | 0 | 0 | 230 | 0 | 0
10894293 | 2022-04-19 00:00:00 | 2022-11-11 00:00:00 | 2022 | Q1 |  |  |  |  |  |  |  | 10894293 | 2022-04-19 00:00:00 | 2022-11-11 00:00:00 | 2022 | Q1 | 0 | 0 | 0 | 0 | 0 | 0
10894293 | 2022-04-19 00:00:00 | 2022-11-11 00:00:00 | 2022 | Q2 |  |  |  |  |  |  |  | 10894293 | 2022-04-19 00:00:00 | 2022-11-11 00:00:00 | 2022 | Q2 | 0 | 0 | 0 | 0 | 0 | 0
10894293 | 2022-04-19 00:00:00 | 2022-11-11 00:00:00 | 2022 | Q3 |  |  |  | 181 |  |  |  | 10894293 | 2022-04-19 00:00:00 | 2022-11-11 00:00:00 | 2022 | Q3 | 0 | 0 | 0 | 0 | 0 | 0
10894293 | 2022-04-19 00:00:00 | 2022-11-11 00:00:00 | 2022 | Q4 |  |  |  | 230 |  |  |  | 10894293 | 2022-04-19 00:00:00 | 2022-11-11 00:00:00 | 2022 | Q4 | 0 | 0 | 0 | 0 | 0 | 0