How to Auto Fill Column Titles With Row Text

[mwig]

Hello community, 

I am faced with a couple hundred files which are to be imported to Power BI and I must rename the columns based on the 2rd row in each sheet. What is the best way to automate this?

For clarity, each sheet that I am uploading have identical templates - and each of them has the title for the columns in row 2 - and instead of copying and pasting for days - I'd like to use script that will take the text in the second row and [in the same order] rename the columns.

Please let me know if more information is needed!

Thanks!

[ImkeF]

Hi @mwig

the following function renames all columns from a table (Source) to its values from the 2nd row:

Table.RenameColumns(Source, List.Zip( { Table.ColumnNames(Source), List.Transform(Record.FieldValues(Source{1}), Text.From) } ))

is this what you're looking for?

[mwig]

How do I input that into the sheet? 

[ImkeF]

Please check out this video with instruction on how to integrate M-code into your solution: 

http://community.powerbi.com/t5/Webinars-and-Video-Gallery/Power-BI-Forum-Help-How-to-integrate-M-co...

[mwig]

When I entered the exact formula you posted it gives me an error message and then the entire sheet disappears. I'm sure I have to do some changes to the formula but why would it disable the entire sheet if I type it in wrong?

[ImkeF]

Sorry, but I don't understand what you mean with sheet. Could you please clarify?