I could use some help combining cells!

[CaptBret]

Hi everyone,
Here is what I'm trying to do. I have a set of values in cells in Column A that are filled with colors names, such as red, yellow, blue, green, etc. I have a set of values in cells of Column 2 that are filled with clothing names such as shoes, sox, pants, shirt etc. I have over 100 cells in each column. I'd gladly transpose the contents of column B into a row if I need to. BTW I do not have a lot of knowledge with pivot tables or macros.....

I would like to create a third set of values like this:

red shoes
red sox
red pants
red shirt
yellow shoes
yellow sox
yellow pants
yellow shirt
blue shoes
blue sox
blue pants
blue shirt
green shoes
green sox
green pants
green shirt
etc
etc


I've tried 'concatenate', but I need to edit each and every formula that is created. Is there a way to do this in one shot?



Thank you for any support!

[popipipo]

can you post your xls file.
I have a feeling that you don't need a new column with 100*100=10000 rows.

[CaptBret]

Sure Popipipo, The data is in columns A and B. Columns C and D represent the results that I am looking for.

[Ace_XL]

In C1

=INDEX($A:$A,COLUMN(A1))&" "&INDEX($B:$B,ROW(A1))

Copy down and across till as far as required

[popipipo]

Here a solution
But want do you want with these data??

[JieJenn]

I think for me VBA probably would be a better option since the value will be text.

Please Login or Register  to view this content.

[CaptBret]

Ace XL, Thank you so much!! You have made my day! Cheers! Thank you as well Popipipo, both seem to work just fine! I am creating several hundred unique product titles for e-commerce. Thank you!!!!