I have an Excel workbook where data of a particular type is separated by "header" rows using colons to specify the data type:

:DataType1
FirstDataPoint
SecondDataPoint
ThirdDataPoint
:DataType2
FirstDataPoint
SecondDataPoint
ThirdDataPoint
:DataType3
FirstDataPoint
SecondDataPoint
ThirdDataPoint

The amount of data between the header...