Split output in function of column values

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?

Output

Accepted answers

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!

test_output.yxmd

All comments

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.

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.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703