adding text from several cells into one cell in another sheet

[Niran]

HI,
Please help me out in implementing this.
I want to add the text from all cells in a column to a single cell in another sheet , separating by a comma. when i reach a empty cell it has to stop searching in that column. i want to use offset to acquire the text from a particular cell. EX: search for "comments" in a range(f:P) if "comments" is found. append offset(1,0)+offset(2,0)+offset(3,0) to a single cell and stop when a empty cell is reached.

EX:
.........Comments

row 1 tested

row 2 not tested

row 3 tested


Expected output: tested, not tested, tested