Concatenate values with sort in Power Query

[arcegabriel]

I am trying to concatenate two strings but really my concatenation should be indifferent from the column in which they appear

What I have

a  b  > should concatenate as a, b

a  c  > should concatenate as a, c

b  a  > should concatenate as a, b (same as first case)

This is I really don't care about the order just the combinations. I thought I could resolve this by sorting before concatenating but can not figure out how to do that. Appreciate any assistance 

Table is large so looking for something lightweight if possible

[ChrisMendoza · Accepted solution]

@arcegabriel -

To accomplish like:

Add Column

Custom =
Record.ToList([[Column1],[Column2]])

Add another Column

Custom.1 =
List.Sort([Custom])

Extract Values from Custom.1

[arcegabriel]

Thanks for your help.

In the end I used if / then and compared string 1 to string 2. I was not aware that I could compare strings to determine order.

However your method is much more scalable (longer list) so appreciate it as well