Combine binaries returns null for columns with different header name

Hi LarsP

I am afraid this has to be done by hand. This is cited from official document: powerbi-desktop-combine-binaries

• Transformations were not considered for each individual file before the files were combined into a single table. As such, you often had to combine files, then filter out header values by filtering rows as part of the edit process.
• The Combine binaries transform only worked for text or CSV files, and didn't work on other supported file formats such as Excel workbooks, JSON files, and others.

BTW, combining Excel workbooks isn't support by now. If you'd like remove a row in the middle of the table, you could use "Remove alternate row".

Best Regards!

Dale