Spreadsheet: 880875d1728712881-need-help-reorganizing-a-table-with-pq-or-excel-functions-cph020283-excel-test-8-dv-spill-365-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | What I'd like it to look like (or similar) - some way to line up the name in the Agent column with the Daily Totals number and the Activity.
 |  |  |  | Existing table
 |  |  |  |  |  |  |  |  |  |  |  |  | USPTO_111231
 |  |  |  | Activity | Absent Hours | Date | Agent |  |  |  |  |  |  |  |  |  | Agent | Date | USPTO_111231
 |  |  |  | [NAME], [NAME] |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] | 2024-10-04 00:00:00 | 7.5
 |  |  |  | Date: 10/1/2024 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2024-10-04 00:00:00 | 7.5
 |  |  |  | FMLA_111231 |  | 2024-10-01 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-01 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-01 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-01 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-01 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-01 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-01 00:00:00
 |  |  |  | Daily Totals | 7.5
 |  |  |  | Date: 10/2/2024
 |  |  |  | FMLA_111231 |  | 2024-10-02 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-02 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-02 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-02 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-02 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-02 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-02 00:00:00
 |  |  |  | Daily Totals | 7.5
 |  |  |  | Date: 10/3/2024
 |  |  |  | FMLA_111231 |  | 2024-10-03 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-03 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-03 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-03 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-03 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-03 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-03 00:00:00
 |  |  |  | Daily Totals | 7.5
 |  |  |  | Date: 10/4/2024
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | Daily Totals | 7.5
 |  |  |  | Date: 10/7/2024
 |  |  |  | USPTO_111231 |  | 2024-10-07 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-07 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-07 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-07 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-07 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-07 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-07 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-07 00:00:00
 |  |  |  | Daily Totals | 1.75
 |  |  |  | Date: 10/8/2024
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/9/2024
 |  |  |  | FMLA_111231 |  | 2024-10-09 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-09 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-09 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-09 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-09 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-09 00:00:00
 |  |  |  | FMLA_111231 |  | 2024-10-09 00:00:00
 |  |  |  | Daily Totals | 7.5
 |  |  |  | Date: 10/10/2024
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Meeting_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/11/2024
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-11 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-11 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-11 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | [NAME], [NAME] |  |  | [NAME]
 |  |  |  | Date: 10/1/2024
 |  |  |  | ACD_111231 |  | 2024-10-01 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-01 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-01 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-01 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-01 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-01 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-01 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/2/2024
 |  |  |  | ACD_111231 |  | 2024-10-02 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-02 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-02 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-02 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-02 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-02 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-02 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/3/2024
 |  |  |  | ACD_111231 |  | 2024-10-03 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-03 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-03 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-03 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-03 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-03 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-03 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/4/2024
 |  |  |  | ACD_111231 |  | 2024-10-04 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-04 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-04 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-04 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-04 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-04 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-04 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/7/2024
 |  |  |  | ACD_111231 |  | 2024-10-07 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-07 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-07 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-07 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-07 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-07 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-07 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/8/2024
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/9/2024
 |  |  |  | ACD_111231 |  | 2024-10-09 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-09 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-09 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-09 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-09 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-09 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-09 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/10/2024
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/11/2024
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Meeting_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-11 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-11 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-11 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Mark, Marion |  |  | Marion mark
 |  |  |  | Date: 10/1/2024
 |  |  |  | ACD_111231 |  | 2024-10-01 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-01 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-01 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-01 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-01 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-01 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-01 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/2/2024
 |  |  |  | ACD_111231 |  | 2024-10-02 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-02 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-02 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-02 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-02 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-02 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-02 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/3/2024
 |  |  |  | ACD_111231 |  | 2024-10-03 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-03 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-03 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-03 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-03 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-03 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-03 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/4/2024
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | USPTO_111231 |  | 2024-10-04 00:00:00
 |  |  |  | Daily Totals | 7.5
 |  |  |  | Date: 10/7/2024
 |  |  |  | PTO (Planned)_111231 |  | 2024-10-07 00:00:00
 |  |  |  | PTO (Planned)_111231 |  | 2024-10-07 00:00:00
 |  |  |  | PTO (Planned)_111231 |  | 2024-10-07 00:00:00
 |  |  |  | PTO (Planned)_111231 |  | 2024-10-07 00:00:00
 |  |  |  | PTO (Planned)_111231 |  | 2024-10-07 00:00:00
 |  |  |  | PTO (Planned)_111231 |  | 2024-10-07 00:00:00
 |  |  |  | PTO (Planned)_111231 |  | 2024-10-07 00:00:00
 |  |  |  | Daily Totals | 7.5
 |  |  |  | Date: 10/8/2024
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Meeting_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-08 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-08 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/9/2024
 |  |  |  | ACD_111231 |  | 2024-10-09 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-09 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-09 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-09 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-09 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-09 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-09 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/10/2024
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-10 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-10 00:00:00
 |  |  |  | Daily Totals | 0
 |  |  |  | Date: 10/11/2024
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-11 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Lunch_111231 |  | 2024-10-11 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Break_111231 |  | 2024-10-11 00:00:00
 |  |  |  | ACD_111231 |  | 2024-10-11 00:00:00
 |  |  |  | Daily Totals | 0