Cleaning up 100 column names at one time? List.Zip it good!

List.Zip() is a strange function. It takes a list of lists, and returns a list of lists; so it sounds like it might not do anything. But to the contrary, this is a very useful function that can get you out of a bind with a pretty small number of clicks and keystrokes. A great example is having to clean several column names all at once; trickier than it sounds as you’ll know if you’ve ever tried it; and if you’ve ever tried it you’ve probably gotten 90% of the way there and gotten stuck, lamenting “If only there was a function that handled this!”. Well, this video is going to introduce you to just that function (and also squeeze in another Devo reference).

(If you’ve got an entire folder of CSVs that need to have their names cleaned up, you’re basically going to NEED this if your sanity is something you place value in.)

Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
Share on twitter
Share on facebook
Share on linkedin
Share on email


Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?