What you're saying and showing is rather vague.

What's the logic to this ?
Why duplicates?
Why 3 rows for A1 and 2 for A2 ?
Why blank rows between the A1's and not the A2's ?
How many columns are actually in each table ?
Are these tables true Excel tables or standard ranges ?
What are the headers ?
Where on what sheet does the original data exist ?
Where are you wanting the results to be placed ?

How about attaching a workbook with sample data showing what you are really starting with and what you really want to end up with.