Changing duplicate cells into column title

[jonathan9201]

Hi everybody!

I've recently received a data sheet that looks like this:

John 2017 $85 one
John 2016 $87
John 2015 $88
Jim 2017 $90
Jim 2016 $91
Jim 2015 $84
Jack 2016 $70
Jack 2015 $65

Is there anyway that I can transform the data to the below format:

2017 2016 2015
John $85 $87 $88
Jim $90 $91 $84
Jack $70 $65

Thanks in advance!

 

[rpaulson]

Pivot Table will do the trick