Promote a row to a column in Power Query
In this video (a part of a Power Query challenge), I show you a practical example of how to promote rows to columns in Power Query.
The code
try AddIndex[Column1]{[Index]+1} otherwise null
Watch the tutorial:
To jump directly to the code check minute 5:04 of the video.

Links to the mentioned resources
This video explains the technique in detail:

Was this helpful?
Reader Interactions