Gather one column values from all rows in one new column

[aminsaleh]

Hi,

Inside my orders table there is a child table for items. see below plz:

Is it doable to make a new column that list all items from all rows into one column.

----

So for example:

Row 1: item is chair

Row 2: item is table

Row 3 item is pillow

►New Column value is:

Chair

Table 

Pillow

Thanks very much