www.excelguru.ca/blog/2014/10…
Power Query doesn't require it's Excel source data to be strictly in a table any more. Let's look at pulling Excel named ranges into Power Query.
Open link