Need to get data from several small tables into one large table

I have a series of tables. All share a set number of columns but the number of rows of data varies between each table. Each table has a header and column labels. There is always a blank row between the table heading and the row with column labels and there is always a blank row between the last row of data in a table and the heading for the next table. They look something like this:

Group A
Column Label 1	Column Label 2	Column Label 3
Data 1-1	Data 1-2	Data 1-3
Data 2-1	Data 2-2	Data 2-3
Data 3-1	Data 3-2	Data 3-3
Group B
Column Label 1	Column Label 2	Column Label 3
Data 4-1	Data 4-2	Data 4-3
Data 5-1	Data 5-2	Data 5-3
Data 6-1	Data 6-2	Data 6-3
Data 7-1	Data 7-2	Data 7-3
Data 8-1	Data 8-2	Data 8-3
Group C
Column Label 1	Column Label 2	Column Label 3
Data 9-1	Data 9-2	Data 9-3
Data 10-1	Data 10-2	Data 10-3

---

I would like to find a way to consolodate everything into one large table with the column headers and spaces between tables removed. I would like to retain the table headers as part of the data.

The desired output is something like:

Data 1-1	Data 1-2	Data 1-3	Group A
Data 2-1	Data 2-2	Data 2-3	Group A
Data 3-1	Data 3-2	Data 3-3	Group A
Data 4-1	Data 4-2	Data 4-3	Group B
Data 5-1	Data 5-2	Data 5-3	Group B
Data 6-1	Data 6-2	Data 6-3	Group B
Data 7-1	Data 7-2	Data 7-3	Group B
Data 8-1	Data 8-2	Data 8-3	Group B
Data 9-1	Data 9-2	Data 9-3	Group C
Data 10-1	Data 10-2	Data 10-3	Group C

---

I hope I've demonstrated this well enough. I am very inexperienced with Excel's higher functions such as macros but hope that the solution to this problem is one that will help me learn.

@HerryMarkowitz, thank you, I would appreciate your help. I had hoped that the sample tables I provided in the body of my initial post would have been clear enough but I will simply attach the spreadsheet I am working on here.

@alexander.small, I'm afraid the data I have is not already in a pivot table so there is nothing associating the table headings with the data below it. I understand that I might be able to leverage the built-in pivot table functions to solve my problem but I really don't know just how to do so. I can't simply select all of the data and create a pivot table from that selection. I think it is more likely that an intelligent macro will be the solution for transforming the data but my earliest attempts at one have all failed.

I note that a similar thread from a year ago went unsolved. The author of that thread was looking to combine three tables from three separate worksheets into one large table on a fourth worksheet. His data seems better organized than what I'm working with, but it's interesting to see a similar problem. The thread is: Is it possible to merge multiple tables into one large table?

I have now attached the spreadsheet I am attempting to manipulate in this way. As I was doing so, I found another way to rephrase my problem:
I would like to consolodate all of the data from several tables into one large table. Each of the small tables has the same number of columns, a table header describing the contents of the table, column headers, and a varying number of rows of data. To do so, I am looking for a way to automate the following tasks:
- Put the table headers into a new column alongside the data
- Remove the column headers
- Remove empty spaces between tables, effectively merging all tables into one large table

This is getting somewhere now, thank you. Right now, we have two of the three main tasks handled by the macro:
- Remove the column headers
- Remove empty spaces between tables, effectively merging all tables into one large table

To solve the remaining bit (putting the table headers into a new column alongside the data) we need to:
1) Have the macro identify what is a table header - I can see that table headers always appear as the contents of column A in a row with nothing in column B. No other rows have something in column A and nothing in column B.
2) Copy the value found in that cell.
3) Delete that row.
4) Paste the copied value into column E for the new row.
5) The macro then needs to check if the next row contains a table header (by having a value in column A and nothing in column B).
6) If it doesn't contain a table header, go to 4. If it does contain a table header, go to 2.

Try the last one...
Dont forget checking if everthing is okey or not !

You are welcome.