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.
I'm not sure if this needs to be dynamic but I think you just need to clear the brackets using a replace formula, then use text to columns tool to split to columns by using the comma as a delimiter. Then transpose all the data and clear out the nulls. I set the text to columns tool to 25 columns but this can be adjusted depending on the number of records you may need to account for in the data. However, the # of columns cannot exceed 1000 so we will need to look at a different solution if that's the case.
The solution the @ctthornb123 provided will work, but there is a more dynamic way to split to rows. Use the Text To Columns tool and configure it to split to rows. This will place each item on a new row with out requiring the transpose tool. This is also an option with the RegEx tool.
To remove the brackets you can use Trim(field1,"") in a formula tool.