Help Needed : Break a excel file in many files.

[mjunior7]

Hi all,

 I have a big file like this and I want to break this file in many files ( every time I have a null line). For example: the content between the line 37 and 53 will be one file or a different output. Is it possible?

Thanks in advance.

[DataBlender · Accepted solution]

Hi @mjunior7

You can achieve this with a multi-row formula to create a running filename counter which changes when it encounters a blank row. This is then used as the filename in the output tool to write to various (in my example) excel files.

I've created an example in the attached workflow. It's very simple as there is only one field of data so you may have to strengthen the condition for what counts as a break for a new file in case one of the fields has a bona fide null value.

[mjunior7]

Perfect!!! Thank you so much!