Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
I managed to display it horizontally using a rowtocol() function I got in the internet. However my problem is how to put the year in a proper column,
Assuming I have a table compose of a min(year) = 2002 and max(year) 2010.
Here is a tables records.
This is just one of the records, the year varies , sometimes one acount id only have one year and some even have from 2002 to 2010.
1234 2002 12.5
1234 2004 6.00
1233 2006 2.05
1233 2007 11.00
1444 2009 12.02
1444 2010 6.55
my instructor wants it to extract this way
heading in the excell output file should look like this.