Make a new 'Month' column that will detect the right values

[pal95]

Hi, I have a table like this: 

And I would like to convert it (in Power Query) to a form where I will have only 3 columns:

- Title

- Month

- Value 

The value column should detect what was previously written under the month column for the right name, so, for example,

- Title - CH

- Month - April 2022

- Value - 1

As I have 5 rows and 12 columns, I would expect to have 60 rows and 3 columns after this operation is completed. Is that possible? Thank you 

[Nathaniel_C]

Hi  @pal95 ,

If this solves your question, please accept it as solved so that others may find it more quickly.

Thank you,
Nathaniel

[Nathaniel_C · Accepted solution]

Hi @pal95 ,
Yes this is possible in Power Query by selecting the Title column and going to Unpivot - Other Columns.  Please see my pictures below. I dummied up a table for this.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel