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.
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |