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

[appsheetco]

In a sheet you can Edit > Paste Special > Transposed after copying the row data.  Maybe that helps?

[aminsaleh]

Thanks, but No it does not help @appsheetco