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