Get all combinations from 2 columns?

**racerxar** · 09-21-2011, 03:48 PM

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!

**alansidman** · 09-21-2011, 04:34 PM

This is a very quick and easy action for Access. If you have a copy of Access, you can make the values in each column a table and then create a query without joining the tables and the result is a cartesian solution which appears to be what you are looking for. You could also do this in Excel using MS Query.

Alan

**racerxar** · 09-21-2011, 05:13 PM

Hi Alan, thanks for your answer. I dont know how to use access. Any other idea? Thanks!

**satyajit.pattjoshi** · 09-22-2011, 07:23 AM

Hope Help, find attached file

**alansidman** · 09-22-2011, 08:22 AM

Here is a tutorial on MS Query. If you learn this, then the types of issues you are dealing with will go away very quickly.

http://www.danflak.com/techtips/MS%20Query.pdf

and here

http://www.exceluser.com/explore/msquery1_1.htm

Alan