I'd like to change the formatting of this table to be vertical, grouped by Sample Name. The actual table has 673 fields all in the same arrangement (Name, order, name, order, etc. These column headers are all different for example task name1, order 1, task name 2, order 2, etc).
Sample Name | Task Name | Task Order | Subtask Name | Subtask Order |
Sample 1 | Task 1 | 1 | Subtask 1 | 1.1 |
Sample 2 | Task 1 | 1 | ||
Sample 3 | Task 2 | 1 | Subtask 1 | 1.1 |
Sample 4 | Task 1 | 1 | Subtask 2 | 1.1 |
Desired Result
Sample Name | Task Name | Task Order |
Sample 1 | Task 1 | 1 |
Sample 1 | Subtask 1 | 1.1 |
Sample 2 | Task 1 | 1 |
Sample 3 | Task 2 | 1 |
Sample 3 | Subtask 1 | 1.1 |
Sample 4 | Task 1 | 1 |
Sample 4 | Subtask 2 | 1.1 |
Solved! Go to Solution.