Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Transform rows from certain columns to colunms

Hello all,   I have a very simple question. I have a very long table with many repatitive question. Here is an example:   I would like to tranform this table so as every question be under a...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
8 years ago

Hi Anonymous,

 

In Power Query, do the following:

 

  • Click Question column. The values in this column be used as the names of the columns to be created.
  • Go to Transform tab then click Pivot Column. A dialogue box will appear.
  • Select Answer from the Values Column dropdown.
  • Click the arrow just before Advanced Option.
  • Clcik Don't Aggregate from the dropdown.
  • Then click OK.