pivot - break columns into rows in excel

Question

I have an excel worksheet like this: Dataset

but I want the columns to break into rows by ID and become like this: Desired

Anyone has a clue how to do this by excel?

question from:https://stackoverflow.com/questions/65842953/break-columns-into-rows-in-excel

Answer 1

Enable Powerpivot addin (if you haven't added it earlier)

Step-1 select data Get&Transform(on data tab) then from Table remember to uncheck my data has headers option

Step-2 select column2 to column5 and click Transform - unpivot columns see GIF below

Step-3 delete extra column, and reload data back into excel wherever you want (using file menu in powerquery window only)