Splitting sections of an Excel sheet.

[JetCoder]

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.

[danrh]

Something like this?

If your headers are the same every time you get the file, then you can keep a list of them in a Text Input, bounce it off your data to mark the header rows, then use a Multi-Row Formula tool to copy that down to each of the rows in between.  At this point, you might use a Filter to split the data, depending on what you need to do.

Hope it helps!

[ponraj · Accepted solution]

Attaching a sample workflow for your case. 

[JetCoder]

Ponrah, I checked out your solution but when I tried to open it, it would not open because you have a later version than me. My IT department only allows version 11.3.3.30523 at this time.

[ponraj]

Just try the instruction in the following KO and see if it helps to make the workflow compatible with alteryx designer version you have on your machine. 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Adjusting-Alteryx-Files-for-Different-Versio...

Regards,

Ponraj 

[JetCoder]

Thanks Ponraj! I think the solution will work. Also the link you included worked for the versioning issue! I appreciate all of the replies I received for this issue. Thanks for a great community. I will post my final solution per the example when I finish it. Thanks!

[JetCoder]

Here is my finished example. Thanks for all the help!