How to separate records on a spreadsheet, in batches of 1000 records, on a large, 10K records or more spreadsheet, and leave one, or more, empty rows in between each batch .

How to separate records on a large spreadsheet and leave empty rows in between each batch of 1000?

How to separate records, in batches of 1000, on a large, 10,000 records or more, spreadsheet,
and leave one, or more, empty rows in between each batch? @Spreadsheet-Hacks

This solution is based on the Apache OpenOffice Calc spreadsheet application/software.

Let’s say we have a spreadsheet with 10000 records and would like to separate them in batches of 1000 records and leave three colored rows in between each batch.

Column A has a record ID
Column B has a record Name
Column C has a record Email

——————————————————

Select Column D from row 1 to 10000

Fill Series Down with the start value of 1 and increments of 1

——————————————————

Then add the numbers of each batch, 1000, 2000, 3000 and so on, till 10000.

On a separate Column, say column F;

Select Column H from row 1 to 10

Fill Series Down with the start value of 1000 and increments of 1000

——————————————————

Then copy Column H from row 1 to 10 and paste it 3 times Column D under the last record, starting on row 10001 to row 10030

This will add 3 empty rows in between each batch of 1000

——————————————————

To help identify the separations as you scroll, you can color all the cells to the left of the numbered separators.

Then select Column D and Sort Ascending and extend selection. This will sort the rows and enter 3 empty, colored rows, at each 1000 records.

You can then delete Column D and F

Done.

I hope this helps you!

AAPM1000
@Spreadsheet-Hacks