Forum Discussion
Power Query Combine files containing different Date column headers
Hello all, Please can I ask for your help with an issue I am having combining files in Power Query. I have several Excel files which have a number of columns with a date as the header. Each ...
Hi,
Thanks for the solution HotChilli provided and i want to offer some more information for user to refer to.
hello Anonymous , based on your description, you can refer to the following solution.
in power query, after combing the file, click the invoke custom function step and remove the steps below it.
Then select transform file column, and select remove other columns
Then expand the column.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It looks like it would be better to Unpivot the date columns in the sample file. That will prevent loading errors and you can do any transforms required from a common base.