I am trying to make a pivot table from dataset with Year and Months in separate columns into rows. My issue is I am unable to make multiple months column into row as shown in the sample. As shown in attached screen, I will have center, year, Jan, Feb - Dec and I am trying to pivot it into Period like Jan 2020, Feb 2020 with the values. Any help is greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Year Months in Separate Columns to Pivot table
- Thread starter kabrubru
- Start date
