Hello,
I have the following dataset:
| Status | Activity | User ID |
| New | Activity 1 | 1234 |
| In Progress | Activity 2 | 5678 |
| In Progress | Activity 3 | 90123 |
| Completed | Activity 4 | 90123 |
Based on the "Status" , is it possible to split the rows into different sheets, in an excel output?
- Keep table structure
- Rename sheets with Status' name.
Expected end result:
Sheet 1: rename to "New"
| Status | Activity | User ID |
| New | Activity 1 | 1234 |
Sheet 2 : rename to "In Progress"
| Status | Activity | User ID |
| In Progress | Activity 2 | 5678 |
| In Progress | Activity 3 | 90123 |
Sheet 3: rename to "Complete"
| Status | Activity | User ID |
| Completed | Activity 4 | 90123 |
Thank you in advance.
Solved! Go to Solution.
