+ Reply to Thread
Results 1 to 2 of 2

How to match up and sort columns with same data?

Hybrid View

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    Vienna, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to match up and sort columns with same data?

    Hi everyone,

    I have a long A-Z list of destination (countries in the world) with each different numbers assign to it. I have new data each week and want to compare them side to side. Not all destination will appear each week, only some favorite destination will come up each week.
    Here is a sample of data

    Week 1:
    
    Argentina 0039 	 567,000  
    Poland	 0056 	 438,000 
    Romania	 0104 	 378,000 
    Sweden	 0444 	 378,000 
    Japan	 9141 	 133,000 
    Greece	 0089 	 130,000
    Week 2:
     
    Argentina   4032 	 658,000 
    Vietnam    0268 	 510,000  
    Romania    8087 	 432,000 
    Sweden     2044 	 380,000 
    Canada      3012        339,000 
    Germany    0071 	 292,000 
    Poland	  6053        256,000
    Please let me know if I haven't explain well, and I can help clarify

    I really hope someone here can help me!

    Many thanks

  2. #2
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103

    Re: How to match up and sort columns with same data?

    You best bet is to append each week's data to one long table, with an extra column to indicate the week you received it in. Then you can create a pivot table with all of the data and put the week in the column and country on the row. This will be the easiest way to view the data such that you see all countries and only data where there are intersections with that week.

+ 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