Create Col3 from joining each value of col1 with every value

mohammadanwar · May 10th, 2002, 03:31 AM

Need to create Col 3 that has data from Col 1 and Col2. Not a straight join. Need every value in Col1 with each value in Col2.
See example below
Ex:
Col1 --> A, B, C
Col 2--> 11, 12, 13
Result stored in Col3 should be as follows:
Col3 --> A11, A12, A13, B11, B12, B13, C11, C12, C13

Nibbles · May 10th, 2002, 03:48 AM

Hi,

If column 3 is column C, then in C1 enter:

=A1&B1

Nibbs

mohammadanwar · May 10th, 2002, 03:55 AM

[I know this - Say I have col1 with 3 vals and col2 with 4 vals I need Col3 with 12 values
>>how do I get A1&B2, A1&B3 etc - without havng to type each one]
On 2002-05-10 02:48, Nibbles wrote:
Hi,

If column 3 is column C, then in C1 enter:

=A1&B1

Nibbs
[/quote]

Nibbles · May 10th, 2002, 03:59 AM

Hi,

Sorry, I mis-read your first post. You could try putting this in column 3:

=A$1&B1

This in column 4:

=A$2&B1

Coulmn 5:

=A$3&B1

etc...

Then just add one column to the end of the other afterwards?

Nibbs

[ This Message was edited by: Nibbles on 2002-05-10 03:03 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 03:31 AM	#1
mohammadanwar New Member Join Date: May 2002 Posts: 2	Need to create Col 3 that has data from Col 1 and Col2. Not a straight join. Need every value in Col1 with each value in Col2. See example below Ex: Col1 --> A, B, C Col 2--> 11, 12, 13 Result stored in Col3 should be as follows: Col3 --> A11, A12, A13, B11, B12, B13, C11, C12, C13

May 10th, 2002, 03:48 AM	#2
Nibbles Board Regular Join Date: Apr 2002 Location: Surrey, United Kingdom Posts: 75	Hi, If column 3 is column C, then in C1 enter: =A1&B1 Nibbs

May 10th, 2002, 03:55 AM	#3
mohammadanwar New Member Join Date: May 2002 Posts: 2	[I know this - Say I have col1 with 3 vals and col2 with 4 vals I need Col3 with 12 values >>how do I get A1&B2, A1&B3 etc - without havng to type each one] On 2002-05-10 02:48, Nibbles wrote: Hi, If column 3 is column C, then in C1 enter: =A1&B1 Nibbs [/quote]

May 10th, 2002, 03:59 AM	#4
Nibbles Board Regular Join Date: Apr 2002 Location: Surrey, United Kingdom Posts: 75	Hi, Sorry, I mis-read your first post. You could try putting this in column 3: =A$1&B1 This in column 4: =A$2&B1 Coulmn 5: =A$3&B1 etc... Then just add one column to the end of the other afterwards? Nibbs [ This Message was edited by: Nibbles on 2002-05-10 03:03 ]