Forum Discussion
Trouble with Transpose
You can open the 'Advanced Editor' to get to the code.
The code I provided contains the data source I manually entered. You will need put your source in place of that. As long as your source has the same column names as the example you provided you can just change the source line. If your actual table has different column names you will need to change the code to reflect the actual names.
jgeddes Thanks! Dumb question. Where do I go to put this code in when I'm in the power query?
You can open the 'Advanced Editor' to get to the code.
The code I provided contains the data source I manually entered. You will need put your source in place of that. As long as your source has the same column names as the example you provided you can just change the source line. If your actual table has different column names you will need to change the code to reflect the actual names.