Merging 2 columns into 1 column and grouping

[narender123]

Hi All,

I am creating a table and I have a requirement shown in Below image:

I want to merge Column1 and Column 2 and group by Column 1 as shown result in right side in above image.

Please tell me to achieve the result.

Thanks in advance.

Narender

[narender123]

Thanks, Antonio Mancini, It's working for me.

I just added Distinct function in it.

Narender

[Anil_Babu_Samineni]

Good, I thought it was in script level. Anyhow you got the solution. Glad we were able to help you

[narender123]

Thanks to All.

Narender