I love your videos, they're short and sweet. However, if a sheet has no table and has a Named Range, it could be included as a table. I copied the values of a table to a new Worksheet and named the entire range of values to "Sheet1Range". The problem is that even though it looked identical to other tables, the first row is had not been promoted. After filtering Query1 I added the following: =Table.AddColumn(Source, "Custom", each if List.First(Record.FieldNames([Content]{0})) "TransID" then Table.PromoteHeaders([Content]) else [Content]) That checks to see that gets the field names of the top (first) row of the table and promotes the headers in the table if the first column is not named "TransID". Still a great video!
