Forum Discussion

Bergh's avatar
Bergh
Helper II
4 years ago
Solved

Copy row to multiple rows with same ID

Hi, look at ID:21975, how can I take all this numbers and du like this: 21975  1883724 21975 1883725 21975 1883726   /Bergh
  • tamerj1's avatar
    4 years ago

    Hi Bergh 
    You can create a new table

    NewTable =
    SUMMARIZE (
        TableName,
        TableName[ID],
        "NewColumnName", CONCATENATEX ( TableName, TableName[ColumnName], ", " )
    )