Welcome to our Knowledge Base
Tip: Start typing in the input box for immediate search results.
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:
Was this helpful?
Reader Interactions