I have a problem which I hope is simple to rectify.
Reporting software delivers statistic of sign ups from different countries, e.g over a whole month we might get the following sign ups from these countries.
(I have sorted these alphabetically and just taken a sample)
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bosnia and Herzegowina
Botswana
Bouvet Island
Brazil
British Indian Ocean Territory
Brunei Darussalam
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Canada
However in just one day maybe we only receive sing ups from the following countries.
Australia
Austria
Bahamas
Bangladesh
Barbados
Belarus
Belgium
Bermuda
Bolivia
Bosnia and Herzegowina
Botswana
Bouvet Island
Brazil
Bulgaria
Burundi
Cambodia
Cameroon
Canada
.....
the range in both occurences is from Australia to Canada, and both are sorted alphabetically.
However, in the second instance there are no sign ups from 'British Indian Ocean Territory'. Is it possible to sort the second list and format in the same way as the first. So that it inserts an extra row + 0 as the sign up count for 'British Indian Ocean Territory' so that each countrie's counts are consistent accross the same row rather than doing it manually?
Many thanks for your advice and insights.
atm my rows appear as follows:
Australia Australia
Austria Austria
Azerbaijan Bahamas
Bahamas Bangladesh
Bahrain Barbados
Bangladesh Belarus
Barbados Belgium
Belarus Bermuda
Belgium Bolivia
Belize Bosnia and Herzegowina
Benin Botswana
Bermuda Bouvet Island
Bhutan Brazil
Bolivia Bulgaria
Bosnia and Herzegowina Burundi
Botswana Cambodia
Bouvet Island Cameroon
Brazil Canada
British Indian Ocean Territory
Brunei Darussalam
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Canada
Bookmarks