Insert Row after Change

[mhauler]

I'd like to add a blank row after a single value changes.  Example is below and looking for the most efficient way to address?  Would a multi-row formula work best and what would the expression look like?  All solutions that I've explored are quite cumbersome and interested in doing in the most efficient manner as possible.  

[TimN]

I tried this...

[mhauler]

Thanks.  How would you remove the car name from the rows showing Null?

[DavidSkaife · Accepted solution]

Hi @mhauler 

Here's my take on it, may not be the most efficient though!

[rzdodson · Accepted solution]

@mhauler here is the approach I worked on for you. Let me know if it is what you are looking for.

[TimN]

You can probably simplify this a bit.  Record IDs to keep the sort.