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.
You start by introducing a record id to identify each unique row. You will then use the semicolon to split the data into individual rows using Text to Columns and once ready, group the data by Record ID and the Value which will give you a unique set of values per record ID using the Summarize tool. You can then group it again by record ID, and concatenate the values using semicolon. See below (example attached).