View the data row wise

2 followers
0
Avatar

Hi,

Is there any way to remove the duplicate rows and merge all the data in the single row based on a column?

For Example, I have a data like below:

Col1  |  Col2

1      |   a

2      |   b

1      |   c

2      |    b

I want to groub it by Col1 and for the second column, i want to display remaining rows in a single column like below.

Col1  |  Col2

1      |   a,c

2      |   b,b

 

Can anyone suggest if there is any way to do the same?

 

Thank you in Advance.

Swethha Telu

2 comments

  • Avatar
    Support

    Hi Swethha,

     

    I have an solution that I think can work for you.

     

    First, run a GROUPBY function on your Col1 on a new worksheet.

    Col1 |

    1

    2

    Next, use GROUPCONCAT on your Col2 in a new column on the sheet.

    Col1 | Col2

    1      |   [a, c]

    2      |   [b, d]

     

    Does this help?

     

    Rob

    Technical Documentation

    1
Please sign in to leave a comment.