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.
Take that XML and parse into rows using < as the delimiter. Then cross tab the rows into columns using a group by, such as record ID or using a formula to pull the SSN to a separate field then do the cross tab grouping on it. Then just do a join and replace. Once that is done, rebuild it into XML using a formula tool. Then concatenate all of those fields and use \n for the concat. Done.