How can i change first row to headers before combining files?

[Anonymous]

Hello, I'm new to PowerBi and i ran into a problem. I have a folder with multiple .csv files. Each file has one column name that is the same as all the other files and 3 column names which are unique. These column names are located in the first row of each .csv file.

Example: 

file 1

Date, A, B, C

file 2

Date, D,  E, F

file 3

Date, G, H, I

All these files are together in one folder. When I load this folder in PowerBi the column names of each column becomes column 1, column 2, column 3, column 4.  I want to combine all files in a way that gives me a table with all column names as headers, not in the first row. But when I combine the files only the column names of the first file get promoted to headers. I want my table headers to look like this:

Date  A  B  C  D  E  F  G  H  I 

but now it looks like this:

Date  A  B  C

5-9    5  5  5

6-9    8  6  6

Date  D  E  F

5-9    2  8  3

6-9    4  8  9

Date  G  H  I

5-9    4  6  5

6-9    7  2  6

Does anyone know how i can promote the first row to headers for each file before combining them all and how to combine all files in a way that shows the unique columns of each file?

[PurpleGate]

Ah, then you should try this:

1. Combine the files, like you currently are. 

2. Go to the power query tab and in the applied steps, delete all the steps until you get to transform file

3. Click expand transform file

4. then you get all the columns 

[Anonymous]

if I do that i'm not getting any of my column names just column 1 etc. 

[Anonymous]

My problem is that i have to much files to load them individualy so i load 1 folder and when i do that, i can not promote headers before combinig them. 

[PurpleGate]

You can promote first rows to headers in the Transform tab.

Then in the home tab, you can merge the tables together based on date so all unique columns will appear at the top.