Rename Column Headers Based on Excel Table | Power Query

In case you want to Rename Column Headers Based off an Excel Table in Power Query, you have to create a list container with the equivalent of the Table.RenameColumns step.

[rwilson]

Thanks for this. This method is by far the cleanest, simplest and quickest method I've seen so far. On top of that, IT WORKS!

[dodettesky]

The simplest and most straightforward way to rename columns in bulk, and the clearest explanation as well. It works perfectly! Fantastic video! I just subscribed.

[sjdaa]

That was really slick. MUCH better than boring, error-prone typing inside a query. Thanks much for sharing!

[RaviGupta-monf]

How do I do this in the following scenarios:

1) Header has say 3 columns. But my Rename header list has more than 3 columns to account for headers from other similar tables.
when I add a fourth row, My query breaks.

2) I try to append 2 tables each with 3 columns.
There are 6 different names but need to be changed to 3 names only.

How to do this?

[reenamohanta]

What to do if the column we want to rename is not present in the table.. how to make this dynamic

[RaviGupta-monf]

Ok..I got it!!

I know I did not give you enough time.
Let me have your solution & I will share mine.