Hi..... I can suggest an approach for this. 

Let your table be TABLE_A with data as below:

Column_1    Column_2    Column_3

1               A               XXX

1               A               YYY

2               B               XXX

2               B               YYY

Now you want the result...

Hi,

     Could you be more clear about how you get the data to the stored procedure?