How to Rename Column Headings with Power Query - the quick automated way

How would you handle the error that the field name already exists in the record? I have that error and although I can tell the rename function how to handle missing values there isn't anything tat will say this is what to do when you have an existing name.

That's a lifesaver! It's exactly what I need for my current task at work.

Thank you so much!!!!

Hi Wyn,

My approach was: Use Headers as first Row, Transpose, Apply transformations needed to column 1 which contains the names of the original columns. Transpose, Use first row was headers

Very Useful 😮 Impressive 👏

very helpful, thanks

Awsome! I have seen other long approaches but this is the one. Thanks a lot Wyn

I have a question based on the power query how can I get in touch with you? Do you have an email address or any other means of communication apart from this platform?

very nice lecture specially: Shift+Down Arrow selects the step name, then Shift+9... wonderful

Great video! Related to your “clicks” comment, how much M do you write in your work now? I feel like I’ve reached a place with PQ that that is what I should focus on now, but seldom feel like I have a use case that can’t be solved with the “clicks.”

Awesome tips!!!

Nice trick. And I love Shit + 9 😉

Hi Wyn,
Here's a one step solution that gets straight to the point. In your rename step use this formula:
= Table.TransformColumnNames(Source, each Text.AfterDelimiter(_,"_"))
and be done with it. 🙂
You're welcome.

Love it