Is it possible to concatenate the multiple rows and columns based on the reference value?

[jkevz]

Hi! I want to ask if is it possible to concatenate the rows and columns of another table (related table) and paste in 1 cell or field. Please see below screenshots:

Below Screenshots is my Log Sheet details where my Related Customer Items (another table) is currently shown. Each customer orders has a unique work order references.

What I wanted to do is to concatenate all the Customer Items that is related to the unique work order reference and paste it into my task description field in the Log Sheet (table). I tried to concatenate below screenshots but it got me all the data that is listed in Customer Items (table).

@GreenFlux , @Steve 

[Steve]

The expression you tried is close to what you want, but remove the table names:

[jkevz]

@Steve Task Description is under the table of Customer Log Sheet. And for those data's that I want to concatenate are the data's under the table of Customer items. Please find below screenshot if I removed the table name 👇

[jkevz · Accepted solution]

@Steve Thanks for the reply, I already solve my issue. Below is the expression I needed 👇

CONCATENATE(SELECT(Customer Items[Concatenate], ([Reference Number] = [_THISROW].[Work Order No.])))