Oct 13 2020 07:41 AM
Oct 13 2020 08:14 AM
In general Power Query shall work especially if you receive your data as Excel/csv/text file. When query the source and unpivot on columns with months. Sorting by proper months order will require some manipulation and not clear from here year 2020 is taken.
Is your source data have exactly the same format / layout as in your sample file and is it in separate file or not?
Oct 13 2020 11:20 AM
Oct 14 2020 02:15 PM
Generate by Power Query table is here
entire columns with source data are named as Range. Idea as in previous post.