Dynamically find and filter header rows and promote them in Power Query
Dynamically find or filter 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.
Table of contents:
00:00 Describe the use case
01:00 Find the header row solution
03:00 Outro
Watch the tutorial:

Was this helpful?
Reader Interactions