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 |
@bryanmac_92
Here's one way:
I added in a few extra steps to ensure your columns were in the correct order