title: How to pivot duplicate rows to columns?
body: <p>having a hard time figuring out how to pivot a multi-column data set with duplicate rows into unique columns.</p>
  <p><a href="https://i.stack.imgur.com/Z7wBJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z7wBJ.png" alt="This is what I'm trying to achieve" /></a></p>
  <p>I have done research and found some VBA scripts to do this, but it is resulting in data missing when I do counts to confirm it pivoted correctly and ends up adding in duplicate columns (name/ rating year) over and over.</p>
  <p>Anyone have any ideas? I'd do a pivot table, but I can't display the actual rating values in a pivot, only a sum/count/avg. etc...</p>