Import folder with files that has different headers and still keep the different header

Hi PatrickWong 

Not sure what you have in mind when you ask for it to be 'corrected'. 

The best way to fix this would be to have the data sent to you in the proper format - tabular data - i.e. not using dates as column headers, but having a Date column and a Value column.

But given what you have, and starting with data like this

Right click the column header for the Description column and Unpivot other columns to give this

Regards

Phil

Hi PatrickWong 

Here's an example PBIX file

You should be selecting the Description column then unpivoting other columns.  That way the 'other' column names aren't explicitly mentioned in the query so should work for all files.

Regards

Phil