Look within a large array of values for a small array that meets a certain criteria

Hi everybody, I have attached an example spreadsheet with a set of data that I would typically get on sheet1 and then what I am hoping to to accomplish on sheet2. Basically, I have one large array of values, called "RAW DATA", with multiple sub-groups inside and I am trying to look for those sub-groups and get their means and standard deviations for each row #. Each sub-group has its own "Name" (1A, 1B, 1C, 2A, 2B, 2C) and set of sequence values (1 through 5). My goal is to try and automate this process of going in and selecting sets of data from each sub-group to be analyzed for mean and standard deviation. The tricky part is that the sub-groups come in all different array sizes for different sets of raw data, so the number of serials could be 5, 20, 200, etc... My initial idea was to use the sequence numbers "1" as a signal for the start of the next sub-group and that all data within that row up until the cell just before the next "1" in the sequence would be used for the mean and standard deviation calculation. I would appreciate any help that I can get!

Note: The raw data spacers in sheet2 are optional (just looks nicer). Sheet2 is just there to show what I would like to have as my end result.