View the data row wise

Follow

Swethha Telu

• May 11, 2017 08:45

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.

0

• 

  Support

  • May 11, 2017 10:01

  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

  Comment actions Permalink
• 

  Swethha Telu

  • May 18, 2017 05:13

  Hi,

  Yeah, the solution is helpful.

  Thanks alot.

  0

  Comment actions Permalink

Please sign in to leave a comment.