I'm sure this question has been floating around for a while. I haven't found a satisfactory answer yet to my specific concern. So, I have a master excel file of data (both string and numeric values) that needs to be divided into many excel files based on the category (say: delta, beta, alpha etc) which is in a certain column.
A way to do this could be that these values are at certain specific rows. Delta values are at row 5,10,15,20,25....Same with the others. Any way I can read the file into a matrix and seperate out delta values into a file and alpha into another and so on?