Simple List of Combinations From Single Row Table

[Peter Bedrosian]

Note: Novice User, using Excel 2013.

I want to create a non-repeating list of possible combinations/permutations from a single column table.

I want to make a simple table called "letters". The number of items will vary. I'm using alphabet characters in the example but imagine these could be easily apples, oranges, salad, drink....and so on.

In a separate tab I want to generate a list of non-repeating combinations, order does not matter, and I want to run this list in varying string length (1x, 2x, 3x, 4x, ...) until final result with all items combined. Sample output I imagine would be:

A

B

C

D

AB

AC

AD

BC

BD

CD

ABC

ABD

BCD

CDA

ABCD

If possible from formatting perspective, I would like to display the combinations separated by "+" character.

Any help would be appreciated.

[#2]

This is not possible in Excel??

[#3]

Hi Peter,

General answer - it shall be possible.

Similar cases are, for example, here

http://www.excelforum.com/excel-general/596215-listing-all-combinations.html

https://www.get-digital-help.com/2015/02/26/return-all-combinations/

If more concrete, how to do that in your concrete case - have no ready to use pattern.

[#4]

Thank you so much sir, I was searching solution for the same type of combination for last few days, searched everywhere but no result but now i hv solution because of you.
thanks you heartly