Data items in Columns

[meghanshbajaj]

Hello people,

I have several data items in a list but not limited to Name, Company, Year, Province & Revenue. The data is currently as:

Name     Company     Year    Province    Revenue
ABC        Tech_1        2017   CA            25000
ABC        Tech_1        2018   CA            29000
ABC        Tech_1        2019   CA            35000
DEF         IT_1           2017   NY            12000
DEF         IT_2           2018   NY            90111

I want the output as:

Name     Company     2017     2018     2019
ABC        Tech_1        25000   29000   35000
DEF         IT_1           12000   90111

Note: Crosstabs are not working because i have around 20 other columns and thousands of rows. Any solution will be appreciated. Thanks.

[dougp]

Based on what you posted, a crosstab is the best approach.  Why would the number of columns matter?  How would it not be a problem with any other solution that produces the same result?