Row merging concatenation

[coolguy123]

i have table with row see sample data picture

i need to merge all rows into 1 row how can I do this,  merge on ID

column heading is  same but it but data in multiple rows 
 
i try concat(id) not working 

do I do this script  or table dimension?

thanks for help

[sunny_talwar]

If this is needed in a straight table or pivot table, you can simply use ID as dimension and convert all other to expressions like these -> Concat(DISTINT [customer join date], ','), Concat(DISTINT [Location], ','), Concat(DISTINT [Director Name], ','), and so on....

[coolguy123]

you mean expression as measure and I type it in ?

you mean distint or distinct ?

thnaks friend 

[sunny_talwar]

Yes, I meant measure. And also, Yes, I meant DISTINCT

[coolguy123]

you are genius thanks 

is it possible to create table in script?

i have too many coloumns?