how do I make a data that look like below picture and change it to "to be"

What i'm trying to do

The picture will explain. i have a very long row of data that need to move in to 1 row, is there a easy way todo without copying and transpose row by row


You can use Power Query to get the result:

  1. Select Range and go to Data- From Table/Range (uncheck "My table has a header"): enter image description here

  2. Select all Columns- Go to Transform- Unpivot Columns- Remove column Atribute: enter image description here

  3. Close and load data: enter image description here

|improve this answer|||||
  • 2
    This is the best answer I have seen on SE ever! gifs? Really? You are making the rest of us look bad! Keep up the good work! – Randomhero Apr 17 '19 at 8:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.