00:00This is how you can split group of data in a Jiffy that looks like this.
00:04First, you're going to select any empty column. I'm going to select column D3 here and say equal
00:09A2 equal A3 and hit enter. Once that's done, double click on this handle to apply the formula
00:16to the rest of the rows. Next, select any of the cells on the header and press ctrl shift L
00:20to enable filter. Now you're going to filter the data set based on false only and click OK.
00:27Now select all the visible rows and press alternate semicolon to select only the visible cells here
00:34and after that, you're going to right click on this row here and hit insert row and then go back to your
00:40header and then press ctrl shift L to disable your filter. Now all you have to do is to apply the
00:46header like this and as a part of cleanup, you can actually get rid of this column here and all done.
