



September 14, 2021

Good day,
I have a file that has sections separated by blank rows and merged columns in one worksheet.
want to use PowerQuery to pull out specific sections of the report based on a title of the specific cell reference and stop when there is a blank row.
Then repeat this process for a subsequent section in the worksheet.
Please see attached pic for details.
[Image Can Not Be Found]


Trusted Members

October 18, 2018

crossposted: https://www.mrexcel.com/board/.....e.1181744/


November 8, 2013

In the attached file, change the path to your sample file in the "Test" query.
Basically, the idea is to add a new column to identify the target headers, fill down that column then remove nulls. Grouping by that custom column will create a table with 2 rows, with data separated for Failed and Manual. The tables are extracted into 2 separate queries loaded to sheets.
Next time, please don't forget to add links to other sites where you have posted your question, nobody wants to waste time solving a problem that was already solved elsewhere, cross posting may potentially be a free time waste for many enthusiasts.
Welcome to our forum!


September 14, 2021

This was very good information. Thank you
I found Ruth's video that helped me create an index column and use the following to dynamically find "Failed Transactions" - the first section of the report that I need. I'll promote this row to headers.
Dynamically find header rows and promote them in Power Query - YouTube
I'll promote this row to headers.
My current issue now is this...
I need to keep the data under "Failed Transactions" until the FIRST blank row, AND then delete all the cells after this first blank row ("Manual Transaction" will come after this blank row, which I want to delete all these rows and I'll make this section its own query as you suggested).
Any suggestions?
1 Guest(s)
