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 |
