I have some data, contained in a spreadsheet, generally arranged in a fixed
number of columns. I need to do some simple analysis of these columns of
data. Easy enough. But.....
The data comes in to the spreadsheet as different "groups" of data, with
each group having varying numbers of rows, but all using the same columns.
Furthermore, each group of data has a single row "title" to identify it.
There are blank rows between each group

Example:

Group 1
10 lines of 6 columns

Group 2
8 lines of 6 columns

etc.

The type of data in each column is the same. How do I extract/analyse the
data that is contained in each part of the column that relates to each group
of data? I don't want to have to manually rearrange the data as this will be
time consuming. Sorry if this is a simple question, but I am a simple user!
Help would be much appreciated.