Hey there,

I need to transform allExcel files in a folder via Power Query and merge the results in one new data sheet. 

The transformation for all files is the same, but the results differ slightly as there is a different amount of columns. I need to have every existing column and non existing information should be left blank.

Is there any way to do this completely automatically via Power Query?

I hope my intention and my description is clear enough!

Thanks a lot in advance!

Kind regards,
Tobias

This video by Miguel Escobar should be helpful:

http://www.poweredsolutions.co/2015/07/13/combine-consolidate-or-append-multiple-tables-from-any-source-with-power-query-for-excel/

• Marked as answer by Tobias Weysters 24 minutes ago

This video by Miguel Escobar should be helpful:

http://www.poweredsolutions.co/2015/07/13/combine-consolidate-or-append-multiple-tables-from-any-source-with-power-query-for-excel/

• Marked as answer by Tobias Weysters Friday, September 11, 2015 7:01 AM

This video by Miguel Escobar should be helpful:

http://www.poweredsolutions.co/2015/07/13/combine-consolidate-or-append-multiple-tables-from-any-source-with-power-query-for-excel/

• Marked as answer by Tobias Weysters Friday, September 11, 2015 7:01 AM

Hi Tobias,

You could refer to the answer of Bda75 and check if the video works for you.

If you need more help of how to use Power Query, I suggest you post your issue to Power Query forum:
https://social.technet.microsoft.com/Forums/office/en-US/home?forum=powerquery

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Regards,

Emi Zhang
TechNet Community Su