+ Reply to Thread
Results 1 to 2 of 2

Sorting Columns to a set Format.

  1. #1
    Forum Contributor
    Join Date
    05-05-2006
    Posts
    143

    Sorting Columns to a set Format.

    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

  2. #2
    Forum Contributor
    Join Date
    05-05-2006
    Posts
    143
    note: I have looked at Custom LIsts sorts, but I cant use this to also insert rows to make the sorted columns align with each other.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1