Hi,
Ok, the title might sound simple and it is quite easy to do manually, but it takes for ever to do. I am trying to sort the data from a horse racing form list for 13 horses. (and before you ask, the selection programme I've already written might fail totally, It's about the journey) So there is up to 24 lots of horse form data, each lot starting with 1 then 2 then 3 for each horse etc etc up to a possible 24 horses for the Melbourne Cup. So we know the start of each lot of data (1,2,3,4 etc) and we know the data for each horse finishes 46 rows later. The catch 22 is that, between each lot of 46 rows of data I require for each horse, the number of rows in between is a variable. could be 20 rows, could be 30 rows??
So, If I have the column of 2500+ rows of data in column A, I want to extract the 46 rows of data for each horse to start at column B1 for 46 rows, then C1 same, then D1, E1, F1, G1, etc etc etc. Hope this makes sense and hope someone can help. Thanks in advance. attachment for example "Horse form data"
Bookmarks