Hello.
The column I actually have is address1.
I want to change the contents of address1 to address2.

I think i should proceed in the following order.
1. Delete () and what's inside
2. Clear the space.
3. Change "Westwood" to "West."
4. Erase "village" and "AZ"
5. If you have the same id, match the address with the address of the first id.

Is it possible?

Oh, and is there any way to check if the ID duplicates the same date in the panel data?

Array