Dynamically Extracting Tables from a single excel sheet and then Union them Manually

[JashwanthK]

Greetings of the day,
 
I have a very long excel spreadsheet wherein I have multiple tables separated by two blank rows at the end of each table. 
I want a way using which I can extract all these tables and union them manually to create a single large table.

I am attaching images of the input and expected output with the spreadsheet input file.  

Many thanks in advance for any answers and guidance,
Jashwanth Baba

[JashwanthK]

---

@EN6924 wrote:

Hi,

Please check if this works -

Thanks

---

Data might get shuffled here, getting individual tables and then manually unioning them is what I am looking for. 

Thanks for your response.

[binu_acs · Accepted solution]

@JashwanthK one way of doing this