moving data

[Anonymous]

hi am looking to convert the data from the bollow view to eather than having months in the columns but to have 1 column called months with multiple numbers associated with that 1 country for example;

Country                          Month                 Value

American Samoa             December              5

American Samoa             March                   6

American Samoa             April                      7

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, you may use unpivot function:

Result:

Regards,

Daniel He