Split out Column into 2 Columns using another column as delimiter?

Bobbins

Good Morning All,

I have a data import where I need to ignore some rows, then capture some rows, and then capture some rows again for some further data analysis (using select I can run various paths for each column once split)

I have been able to identify the header rows (which are identical) where I need to break, and I know I can delete everything above the first header row, but how would you extract out the data beyond this? The number of rows varies sadly.

Thank you

Example data:

Data	Headers Flag
Data String to be Ignored	0
Data String to be Ignored	0
Data String to be Ignored	0
This is my header row	1
Data String to be processed now	0
Data String to be processed now	0
Data String to be processed now	0
Data String to be processed now	0
This is my Second header row (its identical to first header row)	1
Data String to be processed Later	0
Data String to be processed Later	0
Data String to be processed Later	0

To This:

This is my header row	This is my Second header row (its identical to first header row)
Data String to be processed now	Data String to be processed Later
Data String to be processed now	Data String to be processed Later
Data String to be processed now	Data String to be processed Later
Data String to be processed now

Thank you

TheOC

hey @Bobbins 

I believe i have what you need, with a little bit of a lengthy workflow but it should be dynamic if you have more header rows:

Attached is the workflow,

Thanks.
TheOC

Bobbins.yxmd