Filter out a specific area of an Excel

Hello,

I have an Excel (see attachment) and would like to filter out a specific area (area test field 2 - (DE123456789) / rows 8 - 27).

My problem here: The rows vary from week to week and test field 2 could be contained in lines 20 - 35 in week 2, for example.
The only thing that remains the same is the name of the respective row "Test field X...".

Do you have any solutions on how to solve this problem? I only need it for the test field 2 area though. Thanks in advance!

Best regards
Christian

Alteryx Frage.xls

Interface Tools

Accepted answers

Using multi-row formula can help; once detect data starting from"Detail:..." then add its number.

Also, for your convenience, I configured batch macro to combine all of data. Please reference to attached yxzp WF.

Output look like this(excluded 2nd one)

Filter out a specific area of an Excel_gawa.yxzp

All comments

@Rayyl One way of doing this

Filter_110923.yxzp

Filter_110923.yxmd

Using multi-row formula can help; once detect data starting from"Detail:..." then add its number.

Also, for your convenience, I configured batch macro to combine all of data. Please reference to attached yxzp WF.

Output look like this(excluded 2nd one)

Filter out a specific area of an Excel_gawa.yxzp

Thank you guys!!!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15880

MarqueeCrew 13708

apathetichell 13703