Forum Discussion
Solved
New column sorted alphabetically
I have column A, with many letters separated by a comma. I want a new column B, where i sort column A alphabetically. See example Fig 1 Fig 1 Column A Column B A,B,C A,B,C B,C,A A,B,C...
Hi Vendelin
please try
ColumnB = VAR String = 'Table'[ColumnA] VAR Items = SUBSTITUTE ( String, ",", "|" ) VAR Length = COALESCE ( PATHLENGTH ( Items ), 1 ) VAR T1 = GENERATESERIES ( 1, Length, 1 ) VAR T2 = SELECTCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) ) RETURN CONCATENATEX ( T2, [@Item], ",", [@Item], ASC )
Thanks tamerj1 it work perfekt 🙂