mergegoogle-refine

Merge all the data in the second column for each unique value in the first column

I have two columns of data. Some of the data in the first column repeats (they represent questions). The data in the second column is unique (they represent multiple answers to the same question).

I need to merge all the data in the second column for each unique value in the first column. e.g.:

Q,A
1,yes.
1,is possible.
2,no.
2,not possible.
2,cannot do this.
2,impossible.
3,maybe.

merged to:

Q,A    
1,yes.is possible.
2,no.not possible.cannot do this.impossible.
3,maybe.
Solution
    1. Create a 2 column project in Google Refine
    2. Sort by Q column (if not already sorted) and make sort permanent
    3. Blank Down on Q column to remove duplicate values
    4. On A column, do Edit Cells -> Merge multi-valued cells