New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Insert blank rows at each category in Power Query

Have you ever wanted to have a blank row after each category or subcategory, so you can visualize your data in a table? In this video I will show you how to add a blank row for each group using power query in one step!

Table of contents:

00:00 Intro & Use case
00:40 Group data by a column
01:26 Modify the group data M code to add the blank row

Watch the tutorial:

Insert blank rows at each category in Power Query
Was this helpful?
Previous Get previous row in Power Query – EXPLAINED
Next Split multiple columns into rows without errors in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents