Extract data from many cells into 1 cell

[adman]

Hi, How do I extract data from many cells into 1 cell? I want the data in 1 cell for each tableName and the ColumnName values to follow. Eg:



(Apples,Red,Green,Blue,Orange) to display from the below table in the same cell. And then
(Bananas,Red,Green,Blue,Pink)
(Grapes,Green, Blue,Pink)
(Pears,Red)

each () being a single cell.

tableName ColumnName
Apples Red
Apples Green
Apples Blue
Apples Orange
Bananas Red
Bananas Green
Bananas Blue
Bananas Pink
Grapes Green
Grapes Blue
Grapes Pink
Pears Red

Thanks in advance.