Print

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.

Promote a row to a column - Part 2: Power Query Challenge

Links to the mentioned resources

This video explains the technique in detail:

Get previous row in Power Query - EXPLAINED
Was this helpful?

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents