This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It sounds like you have the Cross Tab portion figured out, but just need to consolidate salary values by employee and year first. I used your example data to first convert the salary data to a numeric field and summed by employee and year. Then a Cross Tab and Rename took care of the rest. Solution attached.