Results 1 to 2 of 2

Pairing data with itself?

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Portland, OR
    MS-Off Ver
    Excel 2007
    Posts
    12

    Pairing data with itself?

    I am using Excel 2007 (and Google Docs! ), and I have a data set of values that I need to associate with itself. In short, I have a column of data:

    A
    B
    C

    I need some trick - be it a function, VBA, or macro - to duplicate that column, and associate every value with every other value. Essentially, generate two columns like this:

    A A
    A B
    A C
    B A
    B B
    B C
    C A
    C B
    C C

    Attatched is an actual example of a data set. I've been mashing my head against this, and figured out a way to make it easier to do manually, but I am struggling and would appreciate whatever guidance can be provided! I have a lot of data sets I need to do this with....
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] pairing items in two sets of data
    By cassiopea in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2014, 07:02 AM
  2. help pairing columns
    By YORKS12345 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 01:16 AM
  3. Data Pairing
    By frankymute in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-23-2014, 01:00 AM
  4. help with Sorting/Pairing data in different columns ?
    By syncguy in forum Excel General
    Replies: 6
    Last Post: 02-09-2012, 04:38 AM
  5. Random pairing
    By woodnwine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2010, 01:01 AM
  6. Pairing two data sets, both with missing data
    By Peter Chapman in forum Excel General
    Replies: 2
    Last Post: 06-10-2008, 04:43 AM
  7. pairing up data in two columns
    By chuckokazaki in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2007, 07:58 PM

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