23 - Dealing with changing column headers in Power Query
Sometimes the column header of your raw data gets changed. This is annoying. Here are three methods to deal with it.
Try Otherwise: Use this if the column name changes between (ideally only) two options e.g. "Name" and "First name"
ListLast: Use this if you can guarantee that it's always the last column that has a variable name
ColumnNames{Index}: Use this if you can guarantee it's always a specific column position e.g. always the third column.
00:00 - Intro
00:15 - Try Otherwise
03:14 - ListLast(ColumnNames)
05:04 - ColumnNames{Index}