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

[wendy_lu]

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:

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.

[s_pichaipillai · Accepted solution]

@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 solution]

works great, Saravanan!