Welcome to our Knowledge Base
Tip: Start typing in the input box for immediate search results.
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 nullWatch 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