Combining multiple CSV files sounds easy—until you realise the column names don’t match across files.
In this post, we’ll walk through how to combine CSV files where the columns are in the same position, but the headers are inconsistent. Power Query doesn’t handle this by default, so we’ll build a custom M code solution that solves the problem dynamically.
