Split a large file into 20K rows columns

do you mean in the same spreadsheet split it into different tabs, each containing the same columns but up to a maximum of 15k rows on each? So every 15k rows, create a new tab?

AngelosPachis

Hi @beatrizmguerreiro ,

I have mocked up a workflow that I think answers your question.

Screenshot 2020-10-07 162128.jpg

I have created a Column ID for each row and then used the modulo operator to get the desired number of rows (15k)

Let me know if that worked for you or you have any questions

Cheers,

Angelos

example.yxmd

beatrizmguerreiro

Same spreadsheet, split it into different columns, each containing up to a maximum of 15k rows on each.

beatrizmguerreiro

Kind of...

The split of the columns worked, however I need to keep the headers and cannot add other headers (that happens with "MOD").

Is there a way to hide this?

Thank you very much for your input and help!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703