Combine multiple table to one on Power Query

Hi Jouworld,

I guess, you are combining files from a folder or sharepoint and got this ugly result.

The way to fix it is to find something like this (this set of queries are created by PQ Editor automatically when you export a quantity of files):

You are interested in the last one which looks like a table and typically would be called "Transsform Sample File".

Open (select) this query and add a step "Use First Row as a header" (you may need to do it a couple of times to push the headers in the headers).

It will automatically apply this to all files being loaded and should sort your issue.

Let me know if this is more complex than this.

Cheers,

John