Unpivot and merge unpivoted 2 columns to one row

[Suhasini1]

Hi

I have data like below 

I unpivoted 2 columns

But need to merge those 2 rows into 1 row

Like below

 

Please help

Thank you

[wdx223_Daniel]

Power Query can not create merge cell, but below code can give what you want almostly

NewStep=Table.UnipovtOtherColumns(PreviousStepName,{"ID"},"R/I -Severity","Values")