Hi team,
I need split lines of a column in more than one columns:
For instance: I have a column with lines as below:
Contract Number
116073086
116214592
116214593
119699214
119732576
119751402
119763184
119789795
119830649
119878480
119885769
119905795
119950290
119950746
119976482
119976946
120007413
120098194
120155178
120157317
I need to split like that:
Column 1 Column 2 Column 3 Column 4
116073086 119751402 119885769 119976946
116214592 119763184 119905795 120007413
116214593 119789795 119950290 120098194
119699214 119830649 119950746 120155178
119732576 119878480 119976482 120157317
Any suggestions would be helpful.
Rgds
Eduardo
Solved! Go to Solution.
Hi @eduardomarchesin ,
Can you give the following workflow a try
Essentially you define the number of columns/ rows within the formula tool, based on the value you use for the mod and ceil functions.
Hope that helps,
Angelos