The output of a script I run creates a complex spreadsheet (Excel 2010) with several dozens of "mini-tables" stacked one on top of another (total of 15 columns wide). In the end, to be able to utilize the important data in other applications it would be great to summarize two rows of data from each of the mini-tables into a 2-column result table. An example of the dataset can be found here (uploaded on my website)


How could I get two columns of data from the spreadsheet - column 1 with player name/number and column 2 with the number of INJ's listed (in the row below each player name)? I've tried everything I'm capable of! Any help or solutions would be great!