Split output in function of column values

[lacubata]

Hello all,

I have an excel file with this format:

A	B
1	XXX
3	XXX
…	XXX
200	XXX
205	XXX
214	XXX
…	XXX
314	XXX
319	XXX
332	XXX

I want to split the output in function of the values of the A column (1-200, first output; 201-400, second output... until the end). I cannot make the max records per file because i dont have all the values between 1-200.

Is this possible?

[Ladarthure]

Hi,

multiple possibilities here, if you want to output from number 1 to 200 and so on even if there is a file with missing values, or if you want to output in multiple files with 200 rows each.

[lacubata]

Hi,

I want multiple outputs. With the previous example the outputs should be:

Excel1.xlsx

A	B
1	XXX
3
200	XXX

Excel1_1.xlsx

A	B
205	XXX
214	XXX

Excel1_2.xlsx

A	B
314	XXX
319	XXX
332	XXX

Thank you.

[Ladarthure]

Hi, here is an example with both solutions, the upper one is the one you need, the only thing you have to do is in the if function go to a potential maximum.

[lacubata]

Hello,

The problem is that my A column goes until 100.000, so filtering manually 200 to 200 is not possible.

Also, in the upper one i see that the values are grouped but i don't know how to split the output in function of that values.

[Ladarthure · Accepted solution]

Foir the output part, you have to use the second formula tool and use the output file configure it to change the entire file_path so that it generate one file per group.

For the group function, you could use FLOOR([A]/200) which is a lot more dynamic!

[lacubata]

Thank you so much!!! It worked perfectly :)