convert distinct row values and into a new column with a seperation

Question

I have a need to take the distinct URL values and convert them into a new column like this:

input file:

I need to take the different values of " google.com/URL*" and paste into a new column so I can further proess my data&colon;

Output:

Since the values are seperated by "URL by Countries", what are the tools that I could use to achieve my goal? Thank you in advance.

Attached is excel file.

Alteryx Countries.xls

s_pichaipillai · Accepted Answer

@wendy_lu

try the attached one

what i did was,

1. removed all extra null rows

2.Used Multi Row formula to update the URL field

thanks

Saravanan

wendy_lu · Accepted Answer

works great, Saravanan!