When I work in Power Query on one of the sheets that I loaded from another excel workbooks I do some manipulation.
Unpivot, Reorder and some other functions. In the end if someone will change one of the columns headers in my workbook all my work will be wasted since in my steps in power query when I checked, I saw that all the manipulation I did in Advance editor are using Column Names .
Is there any other opthion to make the steps (re order, unpivot, etc.) withou using column name?
Maybe you can use a solution I provided in another topic to rename columns by position. So if you include such a rename in the beginning of your query/ies, then you can use that column names in the rest of your code.
As a prerequisite for this solution: the number of columns must not change.