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:
Media
Agent
Count
voice
Joe
13
chat
Joe
5
email
Joe
7
voice
Grace
12
chat
Grace
15
email
Grace
0
voice
Matt
1
chat
Matt
17
email
Matt
15
To this:
Agent
Voice
Chat
Email
Joe
13
5
7
Grace
12
15
0
Matt
1
17
15
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.