Messy data

[Hi2023]

Hi, 

I have to clean up data and need a lil help on how to do it. I think I need a tranpose and formula or Multi row.

If a row has multi owners then it will be not correct and needs to be fixed.

Ex.

Pa name       Pa ad1         Pa ad2            Pa ad3

John              Mary            123 street 

move second owner to Pa ad1 to  Pa Name

move address from Pa ad2 to Pa ad1

if Pa ad3 has value,  and Pad2 is blank then

move value of Pad3 to Pad2 

after, default Pad3 to blank

thanks!

[Qiu]

@Hi2023 
Can you provide a bigger data sample?

And the tricky part is how can we know the string is a name or address?

Do you have any definition for that? like an index table for owners.

[Hi2023]

Is there a way to identify if there is number within a field? I want to see if I can first identify if there is  A number in the string.