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

[Joohyang]

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.

[Yoshiro_Fujimori]

Hi @Joohyang ,

I would Transpose the data to remove unnecessary cells with null() value.

After all the rows are cleansed with the same format, I can transform the data without using "Data start column".

I hope this helps. Good luck.

Workflow

[Qiu]

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

[Joohyang]

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.

[binuacs]

@Joohyang one way of doing with the batch macro