I have an Excel File with 1000 Rows.
I would like to create a CSV from each "X" rows of data.
Each CSV would have the duplicate headers as the source Excel file.
For example, "X" would equal 50 rows of data.
It would be also great to name the 20 CSV files accordingly (the incremental number of total rows in Excel):
Sometimes there will be only one column - sometimes there will be more.
Thank you so much for your time in advance!