Splitting a Table By 1000 Rows

Hey everyone,

I'm wondering if anyone has a suggestion to do this via power query, or within excel? Let's say I have a table with 12000 rows in it. Is there a function within excel (or PowerQuery) to take the first 1000 and dump to a new tab, take the next 1000 and dump to another tab, with the end goal of having 12 tabs or even 12 separate workbooks with 1000 rows of data each? If we can only get it to separate tabs, I can copy and paste it for the time being until we can get a developed process in place.

Thanks alot -

Power Query can do it for sure.

I don't see any transformations for that. Can you tell me where to do it? I'm not looking to split in the sense of text to column, I'm looking to break a spreadsheet up from 12000 rows into multiple tabs with no more than 1000 rows in each. The DataXL add in will do it, but I don't see a way otherwise.

You could do it with formulae, but you would have to set up the 12 tabs manually.

Pete