Results 1 to 4 of 4

Convert table to list

Threaded View

kvn Convert table to list 02-10-2012, 06:27 PM
protonLeah Re: Convert table to list 02-11-2012, 04:04 PM
kvn Re: Convert table to list 02-11-2012, 06:53 PM
protonLeah Re: Convert table to list 02-11-2012, 09:51 PM
  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    Manitoba
    MS-Off Ver
    Excel 2007
    Posts
    2

    Angry Convert table to list

    Hi I am having difficulty converting a table to a list. However the table is a database of distances between cities and the list I want to create needs to omit repetitive data (ex since City 1 to City 2 will be listed first City 2 to to City 1 can be omitted). I also want to omit City 1 to City 1 data as it is redundant. I have attached a spreadsheet demonstrating my data and what I am looking for. Is this possible? Any help with be greatly appreciated.

    Kevin
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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