Gap in data, Offset

Hi

Not sure if the subject title is right, I dont know how else to describe this.  I have UK locations, a column which has a Region and a column that has a County.  As you can see from the picture below; taken from within Power BI Query Editorr, there are gaps, the name of the region does not filter down for each row or correspondining row for that region.  

So this is the view I have in Query Editor.  There is a'null' value for each County following Region first heading, e.g. Nothern-England, line 2 has a 'null' value. 

ModelViewQuery

What I want the data to look like this; I tweaked the table in excel but can we do this in PowerBI maybe?

Excel Version

Once the rows are populated then I will use this to build a lookup table.

Many thanks.

Chris