How to merge excel column data into single row (comma delimited)

I need to merge the ‘Languages Known’ column data and merge into single row using a comma delimited (",").

Employee Name Languages Known Experience
John Java 3
Python 4

And so on…

Also want addition of 3rd col value.

Employee Name Languages Known Experience
John Java, Python 7
2 Likes

Hi @samarth_p

Can you give more details about the issue ? Is this an excel or csv file?

cheers :smiley:

Happy learning :smiley:

1 Like

Hi,

There are many ways to achieve it
I’ll attach one of them as the following.

Sample20191227.zip (16.0 KB)

Hope this helps you.

Regards,

2 Likes

Thanks @Yoichi for your help. It solved my problem.

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.