I have a table with the following columns:
Customer, fiscal year, September, October....all of the months.
1 2019 $500.00 $200.00 .....
I'm trying to change the format to
Customer, fiscal year, month name, amount.
1 2019 September $500
1 2019 October $200 ....
I've tried pivot and unpivot but I'm unable to get it into the proper format.
Any help would be greatly appreciated.