Hi all - I am cleaning address data and need to make a comparison between the values in two columns. I'm not sure how to achieve this but I would like to see if any text is shared between cells. I would then like the common value to be output into a new column. I've attached a sample. Thanks in advance!
Here is the data:
| Column 1 | Column 2 |
| Welwyn Garden City | Luton Airport |
| SOUTHAMPTON AIRPORT | Southampton Airport |
| Inverness | Inverness Airport |
| Great Yarmouth | Norwich Airport |
| St Albans Regus Victoria Sq | London Victoria |
| Bathgate | Castleford |
I would like to output to look like this:
| Column 1 | Column 2 | Column 3 |
| Welwyn Garden City | Luton Airport | |
| SOUTHAMPTON AIRPORT | Southampton Airport | Southampton Airport |
| Inverness | Inverness Airport | Inverness |
| Great Yarmouth | Norwich Airport | |
| St Albans Regus Victoria Sq | London Victoria | Victoria |
| Bathgate | Castleford | |
