I got it!!!! Here is what I did. I unpivoted all forecast Yr1, forecast Yr2, etc column. Then used the column name to pull out the 1 from Yr1, the 2 from Yr2... I then added this number to the Start year in a new column. Deleted the unpivoted column. Then I pivoted the new column which now has the actual year number.!!!!
How do I mark this as solved???
Thanks for your help anyway! Hope my solution helps someone else
Steve
Bookmarks