Need help!!

[rrahu07]

Can someone please help to get output like this screenshot? 

[Prometheus · Accepted solution]

@rrahu07 The first thing I did was create a new field called Output using the REGEX_Match function. After that, I used the Multi-Row tool to fill down using a conditional expression, then used a Select tool to deselect the original column.

 

 

[rrahu07]

@Prometheus  perfect. Thank you so much :)