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?
Solved! Go to Solution.
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.
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.
Thank you so much!!! It worked perfectly :)