Dynamically find header rows and promote them in Power Query

Dynamically find a column header and promote them in power query is a very common requirement, specially if you are importing data from excel or pdfs for example. In today’s video, I will show you how to do that with just a few simple steps! Here you can download all the pbix files: SUBSCRIBE to learn more about Power and Excel BI! Our PLAYLISTS: - Join our DAX Fridays! Series: https://g