I beleive this stuff was manually seperated out using an ETL process.
Thank you Russell. This is most likely the right answer. I was wondering whether the region and subregion columns can be downloaded directly from WBD with the countries, series and years. I was unable to do this. Finally I gave up and manually defined the regions and subregions by grouping the countries - it took a long time. I have one problem - I do not know what an ETL process is.
I have now found information about the ETL process by way of Google.