I have been trying different methods and just cant seem to get my head wrapped around this. I have an Excel Sheet that is produced by another group. It comes in with one sheet that has two sections. Each section has a header row. Each section could grow or shrink in the number of rows. The constant is that one of the rows will be the header and it is named the same thing every month. This header will begin the section, the section will end when we hit the next header row. So this would be my indicator as to where I need to start and begin my read. I am used to doing this sort of thing in vb.net by stopping an iteration when I hit that header value but I just can't get my brain to switch gears so I can do this in Alteryx. Below is an example of what I am trying to do. Any help would be greatly appreciated. Thank You!
| Group Assessments |
| Subject | Assessments | Date | Score | | | |
| Blah | Blah Blah Blah Blah | | | | | |
| Blah | yackity smackity blah blah | | | | | |
| Each Month | there could be less records or more records from here on out down to the next header row | | | | | |
| | | | | | | |
| Individual Assessments |
| Subject | Assessment | Date | Score | | | |
| blah | blah blah blah blah | | | | | |
| blah | blah blah blah blah blah | | | | | |
| Each Month | this could keep going until it hits the next empty row. | | | | | |
| | | | | | | |
