Forum Discussion
Headers Power Query
Hi, I am combining several files from a folder. The first column (the source column), I need the column header to stay as "source name", but for the other columns, I need to promote the first row...
@Fowmy Thanks! I am actually trying to do the inverse. I am trying to promote the first row as a header for all columns except the first column. Hope that makes sense.
In that case, what do you want to do with the first value of the first column?
You can rename all the columns with the values of the first row except, then I Jay would be the next step?
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply š