This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
First, record ID each row. You can use the 'text to columns' tool, set your delimiter as , and choose the mode 'split to rows'.
You can then unique on the 'Record ID' field and the 'Lang_Spoken' field.
Finally, to bring them back onto a single line you can use the summerize tool, grouping by your ID field and concatting your 'Lang_Spoken' field. Also group by any other fields you may have in your data.
The easiest way (I know of) to do this is to Use Text to Columns with the setting (output as rows). Then, you can use the Unique tool to limit to one of each unique value, and the Summarize tool to concatenate the string back together.
If you run into issues with this i can put together a quick example!