Results 1 to 7 of 7

Get all combinations from 2 columns?

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2011
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2003
    Posts
    2

    Get all combinations from 2 columns?

    Hi all,
    this is my first post here, hope someone can help me out.

    I have 2 colums with data

    Column A:
    AAA1
    AAA2
    AAA3
    AAA4

    Column B:
    BBB1
    BBB2
    BBB3
    BBB4
    BBB5
    BBB6

    You can get the idea, I need to have them combined in each row but still separated in 2 columns. Like this:

    Col A / Col B
    AAA1 / BBB1
    AAA1 / BBB2
    AAA1 / BBB3
    AAA1 / BBB4
    AAA1 / BBB5
    AAA1 / BBB6
    AAA2 / BBB1
    AAA2 / BBB2
    AAA2 / BBB3
    AAA2 / BBB4
    AAA2 / BBB5
    AAA2 / BBB6

    And so on. Thing is the real data is like 200 values in column A and 900 values in column B, so I cant do this manually.

    Ive attached a sample file so you can see exactly what Im looking.

    Thanks in advance!
    Attached Files Attached Files

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