Forum Discussion
Solved
Demote headers before expanding
Hi, I have a problem with my data. I am reading multiple files in a sharepoint folder. Initially I had csv files, I had some trouble since the name of the files were differents I opted to change for ...
If you go into the "Sample Query" that Power Query generates, you can do the Demote Headers step there, or simply remove the "Promote first row to header" step it probably auto-generated.
If you need more help, can you give some screen shots to more clearly explain the issue?
If you go into the "Sample Query" that Power Query generates, you can do the Demote Headers step there, or simply remove the "Promote first row to header" step it probably auto-generated.
If you need more help, can you give some screen shots to more clearly explain the issue?