I have a spreadsheet that has a number of repeating rows which I would like to reformat (see attached spreadsheet). I would like it to look like this:
Abeera Halim 1
Adrian Kelly 7
Adrianne Gilbert 7
Edward Safo 1
In other words, without all the repeating rows, i.e., just the first column (without the word "Count") and the totals. Short of doing it manually, is there an easy way to obtain it in the format that I need, for example by using a formula, macro, or some other means? The spreadsheet is over 2000 rows long, I just posted a abbreviated version of it.