Hi Guys,
I have a worksheet that has over 20,000 rows of data. For a specific data analysis, I need to randomly divide the data in Sheet1, as per attached file, to chunks of rows. Each chunk of data will have a number of rows between 4 and 40, as per Sheet2 as an example.
So data rows are needed to be RANDOMLY divided to chunks of any number between 4 and 40 rows by inserting an empty row.
Can I get your invaluable input with this matter?
Many thanks in advance.
Bookmarks