Split the lines of a column in more than two columns

[eduardomarchesin]

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

[AngelosPachis · Accepted 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

[eduardomarchesin]

Hi, @AngelosPachis,

It worked perfectly.

Thank you very much for your help.

Eduardo