Curbal has its own social media server on Mastodon. Check it out here!
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 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

Let us know your thoughts...

Table of Contents