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

comma
ID
rows
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Bergh 
    You can create a new table

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

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Bergh 
    You can create a new table

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