Concatenate row values

[Naila EL KHIL]

Hello

I want to concatenate my rowvalues as following:

My table:

 

 

 

ID

Description

 

 

1

Line 1

 

 

1

Line 2

 

 

1

Line 3

 

 

2

Line 4

 

 

2

Line 5

 

 

3

Line 6

 

 

 

 

The expected result:

 

 

 

ID

Description

 

 

1

Line 1

Line2

Line 3

 

 

2

Line 4

Line 5

 

 

3

Line 6

 

 

 

 

I created a calculated column with the expression:UniqueConcatenate([Description]).

My result Calculated column is empty.

 

Do you have any idea about the reason

 

Thanks

[Paul Shumaker]

TryUniqueConcatenate([Description]) over [iD]

If it still returns empty, check forany empty descriptions

[Naila EL KHIL]

That worked.  Thank you 

[Naila EL KHIL]

Hello .

 

UniqueConcatenate([Description]) over [iD]  is working but I can't sort the concatenated description alphabeticaly.

 

(For ID 1 ,  I get something like 2 - 3 - 1 )

 

Do you have any idea how I can sort it in order to have  3-2 -1

 

 

 

Thanks.