Combinations from a single Column

Question

Hi All,

I am trying to create combination from a single column. My input looks like this:

DC NameDC01DC02DC03DC04DC05DC06DC07DC08DC09DC10

My output would have 1023 combinations/rows (this excludes combinations that are repetitive for eg: DC01+DC02 is same as DC02+DC01). My output should look like:

DC NameDC01DC02DC03DC04DC05DC06DC07DC08DC09DC10DC01 + DC02DC01 + DC02 + DC03...and so on

Please let me know if anything is unclear.

afv2688 · Accepted Answer

Hello @agrawaluk ,

I came up with an idea using binary counting:

Regards

afv2688 · Accepted Answer

Hello @agrawaluk ,

It seems the example I shared with you was not fully dynamic.

I have already solved it and shold work perfectly now.

Regards