Dynamically write certain amount of rows and columns when output

[EtamSoko]

hi guys,

I have an output that has 1 column only and can contain up to 5K rows.

How do I create dynamically an out out that splits rows into columns where each column contains only 50 rows and then writes the next 50 items in column on the right?

like such:

A     B    C

1     51   101

.      52   102

.      53   103
.      .       .

46   .       .
47   .       .

48   .       .

49   .       .

50   100  150

I know I could use select records and then join them with the original resource and alwasy take right anchor but I was wondering if there is a better, more advanced solution.

thanks!

ES

[AngelosPachis · Accepted solution]

Hi @EtamSoko ,

Here's an example of how you can do it using a formula tool to cut off the values at every 50 records. I used a text input tool to look up the headers for the different columns that will be created, so instead of having 1,2,3 you will have A,B,C

[joslynzichawo]

Hi, here's an example of how to split the columns. Hope this helps 

[EtamSoko]

thanks a lot! The solution you proposed is not exactly the solution I was looking for. Basically I can have one day 295 rows that needs equal 50 rows per columns, and the other day 4776. The tool is doing the thing with the columns that I want with the rows. Regardless, I was not aware of this tool. Thanks for brining it to my attention!