Hi,
How can I group and pivot my table with keeping the counts the same?
Input
| Category | Date | Day | Count |
| Branded Search | 2/20/2023 | Monday | 11 |
| Display-Retargeting | 2/20/2023 | Monday | 7 |
| Nonbranded Search | 2/20/2023 | Monday | 16 |
| Outreach | 2/20/2023 | Monday | 4 |
| Social Media-Prospecting | 2/20/2023 | Monday | 2 |
| Social Media-Retargeting | 2/20/2023 | Monday | 1 |
| Stealth App - Recruiter/App | 2/20/2023 | Monday | 1 |
| Streaming - TV (OTT) | 2/20/2023 | Monday | 1 |
| Third-Party Providers | 2/20/2023 | Monday | 2 |
| Website-Form | 2/20/2023 | Monday | 29 |
| Website-Stealth App - Marketing | 2/20/2023 | Monday | 15 |
| Branded Search | 2/21/2023 | Tuesday | 9 |
| Database Marketing-Email | 2/21/2023 | Tuesday | 1 |
| Display-Retargeting | 2/21/2023 | Tuesday | 3 |
| Nonbranded Search | 2/21/2023 | Tuesday | 8 |
| Outreach | 2/21/2023 | Tuesday | 7 |
| Social Media-Retargeting | 2/21/2023 | Tuesday | 1 |
| Stealth App - Recruiter/App | 2/21/2023 | Tuesday | 6 |
| Third-Party Providers | 2/21/2023 | Tuesday | 6 |
| Unknown | 2/21/2023 | Tuesday | 3 |
| Website-Form | 2/21/2023 | Tuesday | 37 |
| Website-Phone | 2/21/2023 | Tuesday | 2 |
| Website-Stealth App - Marketing | 2/21/2023 | Tuesday | 11 |
| Branded Search | 2/22/2023 | Wednesday | 21 |
| Nonbranded Search | 2/22/2023 | Wednesday | 15 |
| Outreach | 2/22/2023 | Wednesday | 8 |
| Stealth App - Recruiter/App | 2/22/2023 | Wednesday | 5 |
| Third-Party Providers | 2/22/2023 | Wednesday | 9 |
| Unknown | 2/22/2023 | Wednesday | 1 |
| Website-Form | 2/22/2023 | Wednesday | 45 |
| Website-Phone | 2/22/2023 | Wednesday | 2 |
| Website-Stealth App - Marketing | 2/22/2023 | Wednesday | 22 |
| Branded Search | 2/23/2023 | Thursday | 14 |
| Display-Prospecting | 2/23/2023 | Thursday | 2 |
| Display-Retargeting | 2/23/2023 | Thursday | 1 |
| Nonbranded Search | 2/23/2023 | Thursday | 16 |
| Outreach | 2/23/2023 | Thursday | 40 |
| Social Media-Prospecting | 2/23/2023 | Thursday | 1 |
| Stealth App - Recruiter/App | 2/23/2023 | Thursday | 5 |
| Third-Party Providers | 2/23/2023 | Thursday | 76 |
| Unknown | 2/23/2023 | Thursday | 2 |
| Website-Form | 2/23/2023 | Thursday | 42 |
| Website-Phone | 2/23/2023 | Thursday | 1 |
| Website-Stealth App - Marketing | 2/23/2023 | Thursday | 15 |
| Branded Search | 2/24/2023 | Friday | 9 |
| Display-Retargeting | 2/24/2023 | Friday | 1 |
| Nonbranded Search | 2/24/2023 | Friday | 15 |
| Outreach | 2/24/2023 | Friday | 6 |
| Social Media-Prospecting | 2/24/2023 | Friday | 1 |
| Stealth App - Recruiter/App | 2/24/2023 | Friday | 3 |
| Third-Party Providers | 2/24/2023 | Friday | 23 |
| Website-Form | 2/24/2023 | Friday | 28 |
| Website-NPC | 2/24/2023 | Friday | 21 |
| Website-Phone | 2/24/2023 | Friday | 1 |
| Website-Stealth App - Marketing | 2/24/2023 | Friday | 10 |
| Branded Search | 2/25/2023 | Saturday | 7 |
| Display-Prospecting | 2/25/2023 | Saturday | 2 |
| Display-Retargeting | 2/25/2023 | Saturday | 1 |
| Nonbranded Search | 2/25/2023 | Saturday | 18 |
| Outreach | 2/25/2023 | Saturday | 25 |
| Stealth App - Recruiter/App | 2/25/2023 | Saturday | 1 |
| Third-Party Providers | 2/25/2023 | Saturday | 18 |
| Third-Party Providers (Affiliates) | 2/25/2023 | Saturday | 1 |
| Website-Form | 2/25/2023 | Saturday | 23 |
| Website-Stealth App - Marketing | 2/25/2023 | Saturday | 10 |
| Branded Search | 2/26/2023 | Sunday | 9 |
| Display-Prospecting | 2/26/2023 | Sunday | 5 |
| Display-Retargeting | 2/26/2023 | Sunday | 2 |
| Nonbranded Search | 2/26/2023 | Sunday | 23 |
| Outreach | 2/26/2023 | Sunday | 2 |
| Social Media-Prospecting | 2/26/2023 | Sunday | 1 |
| Stealth App - Recruiter/App | 2/26/2023 | Sunday | 2 |
| Third-Party Providers | 2/26/2023 | Sunday | 10 |
| Website-Form | 2/26/2023 | Sunday | 25 |
| Website-Stealth App - Marketing | 2/26/2023 | Sunday | 10 |
Expected output
| Category | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
| Branded Search | 11 | 9 | 21 | 14 | 9 | 7 | 9 |
| Database Marketing-Email | | 1 | | | | | |
| Display-Prospecting | | | | 2 | | 2 | 5 |
| Display-Retargeting | 7 | 3 | | 1 | 1 | 1 | 2 |
| Nonbranded Search | 16 | 8 | 15 | 16 | 15 | 18 | 23 |
| Outreach | 4 | 7 | 8 | 40 | 6 | 25 | 2 |
| Social Media-Prospecting | 2 | | | 1 | 1 | | 1 |
| Social Media-Retargeting | 1 | 1 | | | | | |
| Stealth App - Recruiter/App | 1 | 6 | 5 | 5 | 3 | 1 | 2 |
| Streaming - TV (OTT) | 1 | | | | | | |
| Third-Party Providers | 2 | 6 | 9 | 76 | 23 | 18 | 10 |
| Third-Party Providers (Affiliates) | | | | | | 1 | |
| Unknown | | 3 | 1 | 2 | | | |
| Website-Form | 29 | 37 | 45 | 42 | 28 | 23 | 25 |
| Website-NPC | | | | | 21 | | |
| Website-Phone | | 2 | 2 | 1 | 1 | | |
| Website-Stealth App - Marketing | 15 | 11 | 22 | 15 | 10 | 10 | 10 |
