Select Rows between blank rows using Power Query

I have a worksheet that breaks up raw data tables between blank rows. What is the best way to single out each of these tables to their own queries.

There can be 1 or multiple of these tables but they will stop completely after 2 blank rows and a FOR INTERNAL USE ONLY disclaimer

Attached a sample with how the data comes in in the first tab, and then how i want the the queries to look in the next 2 tabs. If there were more Placements (placement 3, placement 4 etc..) then there would be 3rd and 4th additional tabs but there would be a maximum of 10 of these tables.

How consistent is your data going to be to be able to delineate between the tables?

Also the tables have different column headers within.

There are about 30 or 40 types of tables that could potentially be there and those will have headers unique to them. There wont be consistency into what tables or order they would appear in. The only thing consistent is the blank lines in between.

This ended up being kind of a nightmare but i added a bunch of conditionals like if column 1 is blank and 2 is not then column 1. Which i then filled down. Since there are two types of lines only i was then able to separate out the two types of queries and manipulate them individually.

So is this Solved?

Originally Posted by kersplash

So is this Solved?

I think there might be a better way to do this but I shoudl be able to use it with the conditionals.