03-29-2017 16:11 PM - last edited 03-30-2017 10:28 AM
If you've got column headers that are all messed up, cleaning them can be kind of a drag. It can be done all at once using M, but it can take a fair amount of fancy M; often you end up caving and just one-by-one renaming the columns manually. However, if you're lucky enough to know about List.Zip() you can write a much much simpler bit of M to handle that problem nice and quick. In this video, we'll show you exactly how that's done.