@suchitraroutray4705

How they sort automatically?? Starting with ABC

@madhusudhanreddyt2838

if you want to sort those values of a column in ascending or descending order, we can use the optional parameter of the concatenatex function (orderby_expression)

New Column = 
IF (
    SampleData[Column1] = "East",
    "East "
        & CONCATENATEX ( SampleData, SampleData[Column2], "", SampleData[Column2] ),
    IF (
        SampleData[Column1] = "Sought",
        "Sought "
            & CONCATENATEX ( SampleData, SampleData[Column2], "", SampleData[Column2] )
    )
)

thank you for the video