See attached.
This must have been an addition to one of the recent updates, I had no idea until just now.
It solves SOOOO many spreadsheet related issues I have had over the years.
Just wanted to say thank you developers you guys are cooler than fridges.
So happy
haha sorry I wasn't very specific - That was part of the intended fun of my partly pointless post. 
Not making it up though - I have at least 5 posts on 'mrexcel' forums asking about different ways of separating out and reorganising data from rows in the last 2 years. This new betangel feature saves a lot of time for future data analysis.

Not making it up though - I have at least 5 posts on 'mrexcel' forums asking about different ways of separating out and reorganising data from rows in the last 2 years. This new betangel feature saves a lot of time for future data analysis.