Insert Blank Row for each change in a value using Power Query
Power Query in Excel can be used for so many purposes and converting data ready for upload into another system is just one.
In this scenario I show a couple of techniques to insert a row for each change in a group of items.
Did you know a Query can be appended with itself!?
00:00 Intro
00:38 Setting the Scenario
02:14 The Steps
03:56 Appending a query with itself and change a table name to a step name
05:15 Conditional Column
06:48 Alternative approach to adding a conditional column
08:53 Testing with extra data
09:30 Recommended extra elements - renaming and adding comments
Follow me on LinkedIn
Twitter
Access Analytic Training
4 views
468
129
1 month ago 00:03:11 1
Complete machining of a steel mold insert on the RXU1201DSH
2 months ago 00:31:59 1
Movies on Vinyl - VHD The forgotten 1980s Videodisc
2 months ago 01:08:27 1
Muslimgauze – Return Of Black September (1996) [FULL ALBUM]
3 months ago 00:40:33 1
Muslimgauze – Hamas Arc (1993) [FULL ALBUM]
4 months ago 00:18:49 1
I Made a Guitar from LEGO and Epoxy LEGOcaster!!
4 months ago 00:09:58 1
Traveling? 🌴 Tips on Essential English Phrases for Travel | Beginner English Lesson 🧠
4 months ago 00:04:21 2
Origin OS 4 on Vivo X70 Pro+
5 months ago 00:08:32 1
How to Make a Pop-Up Alphabet Book for Children
7 months ago 00:13:24 1
RESTRICTED WWII TRAINING FILM “CRACK THAT TANK“ ANTI-TANK WARFARE 27424
8 months ago 00:10:10 2
The Origin Of The Karen Meme
10 months ago 00:08:06 2
Muslimgauze - Hamas Cinema Gaza Strip
10 months ago 00:03:32 1
NEW BEST HACK POINT BLANK | AIMBOT + WALLHACK and MORE | FREE HACK POINT BLANK 2024
11 months ago 00:28:05 1
George Clinton 1993 BET Documentary Paint White House Black Dr Dre Ice Cube Parliament Funkadelic
11 months ago 00:26:13 1
Massive update on Materials System for Blender-- now works with Cycles!
11 months ago 01:06:36 1
[Leather Craft] Making Leather Watch Strap Step by Step Tutorial
11 months ago 00:06:24 1
Easy Tire Insert Install Using A... Toe Strap? | PB Tech Tuesdays
1 year ago 00:01:40 1
Cadence Essence Spinning Rod
1 year ago 00:01:31 1
How to insert a blank page in publisher before page 1
1 year ago 00:01:36 1
How to insert blank page in publisher
1 year ago 00:01:17 1
How to insert blank underline in word
1 year ago 00:01:27 1
How to insert blank page after letterhead in word
1 year ago 01:01:23 6
ETRONE - DJ Set | Pandemic Rave [HARDTECHNO / ACID] 4K
1 year ago 00:05:40 1
How to Add or Remove Blank Space Between WordPress Blocks? Widgets Tutorial ↕️
1 year ago 00:01:40 1
Стрекоза из проволоки. Поделки с детьми.Своими ручками.