Replace Values in Table Headers in Power Query

Описание: In this video, we see how to replace values in table headers in Power Query.

It is not unusual for the headers of data imported into Power Query to contain characters such as underscores or erroneous spaces that require removal.

This can be done individually on each header and is recorded as one applied step in the query. But if the header names or the number of headers is inconsistent, this is not a good approach.

The Power Query trick shown in the video will replace values in all table headers in Power Query.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1