Transpose or Upivot?

[SAEDG]

Hello everyone,

I am hoping someone can help me with transposing or unpivoting some columns.

I am basically trying to turn this:

Into this in Power Query Editor: 

I've tried unpivoting a few different ways, but no luck with attaching the reponse and the commentary to the same Question and ID.

Any help would be appreciated. 

Thanks!

[SAEDG]

This worked perfectly, thank you!

[DOLEARY85]

No problem, happy to help 🙂

[DOLEARY85 · Accepted solution]

Hi,

1. First i'd duplicate the table,
2. In one table delete all of the comment columns
3. In the 2nd table delete all the question response columns and rename the comment columns to remove the word comment - they should match the column headings of the questions in table one.
4. In each table select only the columns now labed with question # and select unpivot
5. Select one of the tables and merge the other into it joining on the ID and qestion number
6. Expand the column to bring in only the value field of the other table.

Hope this helps,

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍