Power Query - Adding Column/ Specific cell reference

[Jason Wier]

GM.

I have a file that has sections separated by blank rows and merged columns in one worksheet.

I 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.

 

[alansidman]

crossposted: https://www.myonlinetraininghub.com...nce-and-stop-when-there-is-a-blank-row#p22047

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.