How to divide data into two by the field numbers written in the specific column

Question

Hi, is it possible to divide data into two by the field number? but the field numbers are dynamically changing according to the cell in the column name 'Data Start Column'. For example, first row data starts in the field number "4" where '2024" starts. And the field number "4" is written in the 'Data Start Column' column.

So, I added filter tool and dynamic select tool to divide each row with the fixed numbers. but the numbers should be dynamically changed according to the column 'Data Start Column'.

Please help me how to use avoid manual inputting the number and adding same process (filter & dynamic select tools) everytime when the column number changes.

Test File.yxmd

binu_acs · Answer

@Joohyang one way of doing with the batch macro

Test File (1).yxzp

Joohyang · Answer

Hi Yoshiro,

I appreciate your approach. However, in my actual dataset, there are no null values—every cell contains some data. Therefore, one common logic I can apply is to split the data based on where "2024" begins.

Qiu · Answer

@Joohyang 
I am tryng to follow your flow but make it dynamically by using Tile tooll to assign the column number after Transpose tool.

Test File-r1.yxmd