ExcelBanter - All Combinations of cell values in a single Column

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - All Combinations of cell values in a single Column (https://www.excelbanter.com/excel-programming/443349-all-combinations-cell-values-single-column.html)

noname

All Combinations of cell values in a single Column

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

All times are GMT +1. The time now is 08:09 AM.