Merge and transpose columns to seperate rows

[jakeryan56]

Sorry I can't explain this very well but I have the following table with a case_id and up to four values. 

I want to merge all the "value" columns and create a new row for each so that the data is structured like this:

Any ideas? I was thinking this would be something I could do in M query but can't figure it out. 

 

[abatahir]

there is an option unpivot column you just click unpivot other columns.

just an example 

[BITomS · Accepted solution]

If you right click on the case_id header, you should see the option for 'unpivot other columns'.

Selecting this option should give you the structure you wanted.