Convert column values to rows

[Punchin83]

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

 

[alansidman]

Book3
	A	B	C	D	E	F	G	H
1	Media	Agent	Count		Sum of Count	Column Labels
2	voice	Joe	13		Row Labels	chat	email	voice
3	chat	Joe	5		Grace	15	0	12
4	email	Joe	7		Joe	5	7	13
5	voice	Grace	12		Matt	17	15	1
6	chat	Grace	15
7	email	Grace	0
8	voice	Matt	1
9	chat	Matt	17
10	email	Matt	15
Sheet2

Bring your data into the Data Model (Insert Pivot Table) and Pivot your data