Select or Remove Columns Based on Their Position 🤯🤯🤯
In this tutorial, I'll show you how to dynamically select or remove columns in Power Query, using their position within the table.
To achieve this, I'll use the =Table.Schema( ) function, which allows us to identify a table's structure and determine the location of each column.
This technique is especially useful when you want to automate processes and columns change names, but their position remains constant.
Working file available here:
https://drive.google.com/drive/folder...
#MSExcel #PowerQuery #TableSchema #PQFunctions #AlejandraHorvath #Empowered2XL #PowerQueryGirl