I want to prepare a simple bar chart so must first produce a summary.

https://dl.dropboxusercontent.com/u/...ataToTable.jpg

With about a thousand data rows as shown, what would be the simplest
way to do that please?

My pencil and paper approach (after sorting the data by Suffix - Year)
was straightforward enough, but I'm curious to know if there's an
elegant alternative.

--
Terry, East Grinstead, UK