I put questionaires results in excel worksheet. In several columns, the data
is in text format. I want to shows all the text in another worksheet as a
summary of result. I can't find any formula suitable for the task. Any
suggestion?

eg.
In worksheet "Data!"
Col_A
Mary is a good girl.
John nice.
Ruby the best.

I would like to show it on worksheet "Result!"
| Col A
------------------------------------------------
Row 10 | Mary is a good girl.
| John nice.
| Ruby the best.
|
------------------------------------------------
Row 11 |

Uncle O