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 -