| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate All Possible Combinations
I have a spreadsheet with 2 columns. I would like to concatenate each row in
column A with all rows in column B into another sheet. The columns are different lengths and are between 50 and 150 rows long. Example: Column A Column B Dog Red Cat Brown Sheep Yellow Horse In sheet 2 Column A Dog €“ Red Dog €“ Brown Dog €“ Yellow Cat €“ Red Cat €“ Brown Cat €“ Yellow Sheep €“ Red Sheep €“ Brown Sheep €“ Yellow Horse €“ Red Horse €“ Brown Horse - Yellow Help please. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| all possible combinations. | Excel Discussion (Misc queries) | |||
| Combinations | Excel Programming | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| Combinations | Excel Worksheet Functions | |||
| Combinations | Excel Programming | |||
Threaded Mode
