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

⏬ Click Show More to check out the description for info and links⏬

Excel and Power BI users sometime need to rename multiple columns automatically rather than manually. e.g. auto replacing parts of the names, or using a manual table of "Before and After" to rename your columns.

I explain 2 methods List.Zip and the simpler Table.ToRows

00:00 Intro
00:20 The Scenario & the general approach
02:11 Create the From and To table
04:34 Creating the List of Lists using List.Zip
07:54 Table.ToRows method


'**************

Nice single line of code solution from Geert in the Comments to extract everything after the underscore

= Table.TransformColumnNames(Source, each Text.AfterDelimiter(_,"_"))


'****************

File to Download
https://aasolutions.sharepoint.com/:f...


Matt Allington's video
Rename all columns in a table at once...


Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
https://wyn.bio.link/
https://accessanalytic.com.au/

• #howto_style
• #get_and_transform
• #power_query
• #excel
• #power_bi
• #renaming
• #listzip
• #tabletorows