Let’s say I have the following dataset
| Assignment | Due Date | Company |
|---|---|---|
| B | 4/4/24 | Red |
| C | 3/3/24 | Red |
| D | 3/3/24 | Blue |
| E | 1/1/24 | Blue |
| F | 2/2/24 | Green |
After sorting and grouping:
| Assignment | Due Date | Company |
|---|---|---|
| E | 1/1/24 | Blue |
| D | 3/3/24 | Blue |
| F | 2/2/24 | Green |
| C | 3/3/24 | Red |
| B | 4/4/24 | Red |
I want to sort by due date and then also group by company. As you can see I want to go by due date BUT if there are more assignments for the same company that has a due date I want to list the rest of the assignments for that company.
Hope that makes sense!