All Combinations of cell values in a single Column

N

noname

Hi,

I need to create different combinations of a cell with the ones below
it.

for e.g:

Column A
--------------
A1
A2
A3
A4


Output:
----------
A1
A1A2
A1A3
A1A4

A2
A2A1
A2A3
A2A4

A3
A3A1
A3A2
A3A4

A4
A4A1
A4A2
A4A3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Development combinations with exclusion of columns 0
Development combinations with exclusion of columns 0
Remove specific cells in a column. 2
Dynamic pointing to a cell 0
On Entering Data in On Cell Enter a Formula in Another 0
How to create a table of multiple combination 2
Development combinations with exclusion of columns 0
VBA to run all variable combinations in a calculation model and store result 6

Top