Getting value of named range from multiple workbooks

[DaveyD]

I used the following code in a custom column to get the workbook info:

Excel.Workbook([Content])

Then I used the double arrow button to expand the workbook dataI am using Power Query to import data from multiple workbooks
I have no problem getting data from tables in the workbook (by just clicking on the expand column button)
However, I am not able to get the values of named ranges.
This is what my query looks like at this point: screenshot

These are all Defined Name ranges (all being one cell) and I need to get the value of them
The column "TableName" is the name of the defined range, and the "Data" column has the value
This is what is displayed when I click on one of the rows in the Data column: screenshot

How can I accomplish this?
(afterwards I will want to pivot that column with those range names as column headers )

P.S. These are the steps I took to get to that point:

• I imported multiple workbooks using the import from "Folder" option
• I used the following code in a custom column to get the workbook info:

  Excel.Workbook([Content])

• Then I used the double arrow button to expand the workbook data
• Then I expanded the newly created column to extract all the excel data
• Then filtered the columns to get just the named ranges that I wanted.

 

[DaveyD]

I figured this out.
Power Query was considering the named range as a table without any rows, which in turn means that the values were considered the column names.
Therefore, I was able to use either of the following to get the values:

Table.ColumnNames([Data]){0}
Table.DemoteHeaders([Data])[Column1]{0}