Spreadsheet: 845777d1697124890-transpose-and-remove-dups-excel-forum-example
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
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | 225 | 0 |  |  | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | 226 | 0 |  |  | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | 227 | 69 |  | 0 | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | 228 | 172 |  |  | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | 229 | 0 |  |  | 322
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | 230 | 0 |  |  | 251
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | 225 | 0 |  |  | 0
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | 226 | 0 |  |  | 0
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | 227 | 140 | 218 | 352 | 0
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | 228 | 0 |  |  | 0
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | 229 | 0 |  |  | 0
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | 230 | 0 |  |  | 0
AFTER  TRANSPOSITION AND REMOVE DUPS
ASSIGNMENT_ID | 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 | 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 | Q4 | 0 | 0 | 322 | 0 | 0 | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | Q1 | 0 | 0 | 69 | 172 | 0 | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | Q2
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | Q3 |  |  | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | Q4 | 0 | 0 | 0 | 0 | 322 | 251
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | Q1 | 0 | 0 | 140 | 0 | 0 | 0
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | Q2 |  |  | 218
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | Q3 |  |  | 352
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | Q4 | 0 | 0 | 0 | 0 | 0 | 0
 | 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 | Q2 | 2 | 0 | 72 | 72 | 0 | 0
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
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | Q1 | 0 | 0 | 69 | 172 | 0 | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | Q2 | 0 | 0 | 0 | 0 | 0 | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | Q3 | 0 | 0 | 0 | 0 | 0 | 0
9946951 | 2022-07-12 00:00:00 | 2023-01-07 00:00:00 | 2022 | Q4 | 0 | 0 | 0 | 0 | 322 | 251
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | Q1 | 0 | 0 | 140 | 0 | 0 | 0
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | Q2 | 0 | 0 | 218 | 0 | 0 | 0
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | Q3 | 0 | 0 | 352 | 0 | 0 | 0
9946952 | 2022-07-12 00:00:00 | 2023-05-26 00:00:00 | 2022 | Q4 | 0 | 0 | 0 | 0 | 0 | 0