I am trying to sort data in multiple columns and pivot into rows. Basically I have a list that has names with data for certain years with duplicate names. I want it take the data from the duplicate names and merge into new sheet by name.

I attached a sample of the sheet. It has about 800 entries in total.
Sample.xlsx