Help Combining cells

[B. Aikman]

Help. How do I get the following to work easily?

I need to combine each individual cell (35 cells) in worksheet 'A' t
the complete list of cells (974 cells) in worksheet 'B'. Each of th
35 cells will match ALL of the 974 cells (for a grand total of 34, 09
cells). I do not want to concatenate the cells. The end result need
to look like:

Col. A Col. B
AA 10
AA 11
AA 12
AA 13
BB 10
BB 11
BB 12
BB 1

 

[AlfD]

Hi!

That's a very easy result to get. Depends, however, on where the hec
you are starting from.

Where and what is your initial data; what do you want to do to it
other than not concatenate it, for some reason?). Where do you want th
results to appear?

Al