Insert blank row at every value change dynamically
Insert a blank row at every change in a specified column from the data set. I walk through building a robust solution that gives the user a lot of flexibility to insert blanks based on the column of choice
00:00 Introduction
01:07 A case for a dynamic solution
01:35 Caveats
02:22 Building blocks for the solution
04:02 Expand function to insert blank row
05:20 Reduce function-quick overview
06:51 Solution commences
12:50 fixing a REF error within the data
15:00 End of the simple solution
15:22 Making the solution more robust(user can choose column)
18:18 Sorting y column of choice before inserting blanks
21:30 Final Thoughts
Workbook:
https://docs.google.com/spreadsheets/...