I have 4 columns "ID", "Name", Year", & "Amount". The ID is linked to the name. My goal is to create new columns representing each year from 1998-2018 and place the amount associated with the name/id under the respected year. Is this possible? If so, how?
Solved by X. H. in 13 mins