Combine text from multiple columns into one

Hi NourJ ,

There are two solutions. Please download the demo from the attachment.

1. Transform the data using M.

Result = Table.Combine({Table.RenameColumns(Table.SelectColumns(#"Changed Type", {"Col1", "Value1"}), {{"Col1", "Col"}, {"Value1", "Value"}}), 
Table.RenameColumns(Table.SelectColumns(#"Changed Type", {"Col2", "Value2"}), {{"Col2", "Col"}, {"Value2", "Value"}}), 
Table.RenameColumns(Table.SelectColumns(#"Changed Type", {"Col3", "Value3"}), {{"Col3", "Col"}, {"Value3", "Value"}})})

2. Create a new table and establish three relationships.

Cols =
FILTER (
    DISTINCT (
        UNION (
            VALUES ( Table2[Col1] ),
            VALUES ( Table2[Col2] ),
            VALUES ( Table2[Col3] )
        )
    ),
    [Col1] <> BLANK ()
)

Measure =
SUM ( Table2[Value1] )
    + CALCULATE (
        SUM ( Table2[Value2] ),
        USERELATIONSHIP ( Cols[Col1], Table2[Col2] )
    )
    + CALCULATE (
        SUM ( Table2[Value3] ),
        USERELATIONSHIP ( Cols[Col1], Table2[Col3] )
    )

Best Regards,