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
https://www.linkedin.com/in/wynhopkins/

Twitter
https://twitter.com/wynhopkins

Access Analytic Training
https://accessanalytic.com.au/training