What's the fastest or most efficient way to convert my table?

[TMN_help]

Hi! I have a table of monthly goals for FY 2023 - for each group and state.

What's the fastest way in PowerBI to convert my Table 1 (where each month goal is in indivdual column) into Table 2 (which has 1 column for goals and 1 column for Month name) instead?

Table 1

Table 2

I tried to create individual table for each month and then append them together, but I was hoping someone knows a better solution. Thank you!

[AlexisOlson · Accepted solution]

Unpivot the month columns in the query editor.

https://learn.microsoft.com/en-us/power-query/unpivot-column

[v-jingzhang · Accepted solution]

Hi @TMN_help 

Select the first three columns (Group, State, Fiscal Year), then select Unpivot other columns. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

[AlexisOlson · Accepted solution]

Unpivot the month columns in the query editor.

https://learn.microsoft.com/en-us/power-query/unpivot-column