I have a table that has calls from hundreds of employees through 3 media types. Each employee currently has 3 rows in the table, one for each media type. In the first column is the Media, second is the agent name, and in the third is the amount of interactions that agent has had on that media type. What I'm trying to do is change that to a table with the agent name first, then media 1, media 2, and media 3 columns with the respective values per column/row. I have spent hours trying to figure out index/match(with AND) or the merge in Power query. I even tried Pivot tables, but I am in way over my head. Can anybody help?
From this:
To this:
From this:
Media | Agent | Count |
voice | Joe | 13 |
chat | Joe | 5 |
Joe | 7 | |
voice | Grace | 12 |
chat | Grace | 15 |
Grace | 0 | |
voice | Matt | 1 |
chat | Matt | 17 |
Matt | 15 |
To this:
Agent | Voice | Chat | |
Joe | 13 | 5 | 7 |
Grace | 12 | 15 | 0 |
Matt | 1 | 17 | 15 |