• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Concatenate texts for every possible permutations

PP3321

Active Member
Dear Chandoo Community,
Thank you always in advance for your help.

Today, I have 1 problem...could you please help me?

I need to concatenate for every possible permutations.
Please find the attached excel file for the list.

What is the best solution to do this?

Thanking you in advance...
 

Attachments

  • Chandoo Forum.xlsx
    11.2 KB · Views: 7
Last edited:
So, you want list of all possible 2 string concatenation?

What you need is Cartesian Product Join of the table.
Note that this assumes order of join makes it different (i.e. "U0100, U0101" is different from "U0101, U0100").

Add list to PowerQuery (Get & Transform). Copy table and rename it "Table2" or some such (without space).

Then add column to original table (Table1).
=Table2

Then expand the resulting column.

This also considers same string can be joined with own. If that is not the case, you just need additional operation within Query Editor to eliminate those.

Edit: Typo corrected.
 

Attachments

  • Chandoo Forum.xlsx
    42 KB · Views: 7
Last edited:
Back
Top