PowerQuery: Input - Process - Output

Picture: Simple transformation (link). Note: FunctionToApply can be placed on any row.

Note:

Excel.CurrentWorkbook() = All named ranges

Table1 = Range name, selected

[Content] = All three columns, selected

Input{0}[Column1] = 1st cell in range Column1