Spreadsheet: 838674d1691246208-is-there-a-formula-or-automated-way-to-restructure-and-stack-columns-as-shown-in-the-image-formula-test
Sheet: Sheet1

ID | [NAME] | Status | [NAME] | Status | Adam | Status | [NAME] | Status | Lauren | Status | [NAME] | Status |  | ID | Name | # | Status |  |  | Name | # | Status
1 | 0 | Processing | 2 | Complete | 1 | Processing | 0 | Processing | 0 | Complete | 0 | Complete |  | 1 | [NAME] | 0 | Processing |  | 1 | [NAME] | 0 | Processing
2 | 2 | Assigned | 1 | Processing | 1 | Assigned | 2 | Assigned | 1 | Processing | 2 | Complete |  | 2 | [NAME] | 2 | Assigned |  | 2 | [NAME] | 2 | Assigned
3 | 1 | Processing | 3 | Processing | 0 | Processing | 1 | Assigned | 1 | Processing | 1 | Processing |  | 3 | [NAME] | 1 | Processing |  | 3 | [NAME] | 1 | Processing
4 | 3 | Complete | 2 | Complete | 2 | Complete | 3 | Processing | 2 | Complete | 2 | Processing |  | 4 | [NAME] | 3 | Complete |  | 4 | [NAME] | 3 | Complete
5 | 2 | Complete | 3 | Assigned | 3 | Complete | 2 | Assigned | 0 | Assigned | 3 | Assigned |  | 5 | [NAME] | 2 | Complete |  | 5 | [NAME] | 2 | Complete
6 | 0 | Processing | 2 | Complete | 0 | Processing | 0 | Complete | 1 | Complete | 2 | Processing |  | 6 | [NAME] | 0 | Processing |  | 6 | [NAME] | 0 | Processing
7 | 1 | Processing | 0 | Complete | 1 | Processing | 1 | Complete | 1 | Complete | 3 | Complete |  | 7 | [NAME] | 1 | Processing |  | 7 | [NAME] | 1 | Processing
8 | 1 | Assigned | 1 | Assigned | 2 | Assigned | 1 | Assigned | 0 | Assigned | 0 | Assigned |  | 8 | [NAME] | 1 | Assigned |  | 8 | [NAME] | 1 | Assigned
9 | 0 | Assigned | 3 | Processing | 3 | Assigned | 0 | Processing | 1 | Processing | 1 | Complete |  | 9 | [NAME] | 0 | Assigned |  | 9 | [NAME] | 0 | Assigned
10 | 2 | Processing | 1 | Assigned | 0 | Processing | 2 | Assigned | 2 | Assigned | 2 | Complete |  | 10 | [NAME] | 2 | Processing |  | 10 | [NAME] | 2 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] | 2 | Complete |  | 1 | [NAME] | 2 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME] | 1 | Processing |  | 2 | [NAME] | 1 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | 3 | Processing |  | 3 | [NAME] | 3 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME] | 2 | Complete |  | 4 | [NAME] | 2 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | [NAME] | 3 | Assigned |  | 5 | [NAME] | 3 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME] | 2 | Complete |  | 6 | [NAME] | 2 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME] | 0 | Complete |  | 7 | [NAME] | 0 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | [NAME] | 1 | Assigned |  | 8 | [NAME] | 1 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | [NAME] | 3 | Processing |  | 9 | [NAME] | 3 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | [NAME] | 1 | Assigned |  | 10 | [NAME] | 1 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Adam | 1 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Adam | 1 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Adam | 0 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Adam | 2 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Adam | 3 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Adam | 0 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Adam | 1 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Adam | 2 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Adam | 3 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Adam | 0 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] | 0 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME] | 2 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | 1 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME] | 3 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | [NAME] | 2 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME] | 0 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME] | 1 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | [NAME] | 1 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | [NAME] | 0 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | [NAME] | 2 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Lauren | 0 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Lauren | 1 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Lauren | 1 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Lauren | 2 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Lauren | 0 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Lauren | 1 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Lauren | 1 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Lauren | 0 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Lauren | 1 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Lauren | 2 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] | 0 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME] | 2 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | 1 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME] | 2 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | [NAME] | 3 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME] | 2 | Processing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME] | 3 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | [NAME] | 0 | Assigned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | [NAME] | 1 | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | [NAME] | 2 | Complete