Power Query Insert Blank Row After Each Group - 2372

58 Aufrufe

  • Danke für die Bewertung! Teile es mit Deinen Freunden!

    Danke für Deine Bewertung!

admin
Published
Back in episode 2359, I needed to add a blank row after every group of names. Although I was already in Power Query, I went out to Excel to add the blank rows.

Several people commented with code to add a blank row after each group in Power Query. Thanks to @BillSzysz1 @radosawpoprawskiyourfriend769 @GeertDelmulle Rico S and Suat Ozgur for guiding me on how to add one line of M code to my query.

I am at that stage in my Power Query journey that I prefer to do everything in the Power Query editor. Once I switch over to the advanced editor, I try to clean up the step names. And then I add in one line of M code before heading back to the Power Query Editor to finish the task.

Table of Contents
(0:00) Question: Insert blank row after each group in Excel
(1:14) Edit in Power Query Editor Group by Name with All Rows
(1:53) Advanced Editor - cleaning recorded M Code
(2:35) Power Query Table.InsertRows
(3:34) More cleaning in Power Query Editor
(4:10) Need to learn M for super Power Query skills
(4:50) Wrap up with Wally & Nancy
Kategorien
Windows Reparieren
Kommentare deaktiviert.

Als nächstes

Яндекс.Метрика Top.Mail.Ru