Hi say i have 3 tables each have a column "Color" that I would like to merge into one column.
Name | Color |
Ross | |
Joey | |
| Monica | Green |
| Phoebe | |
Name | Color |
Ross | Red |
Joey | |
| Monica | |
| Phoebe | Orange |
Name | Color |
Ross | Red |
Joey | Blue |
| Monica | |
| Phoebe | |
Joining on Name does not merge the columns. I tried using a formula to concatenate the 3 columns, but the row "Ross" comes up with "RedRed". I would ideally like a table like this. How could i do this? Thanks!
Name | Color |
Ross | Red |
Joey | Blue |
| Monica | Green |
| Phoebe | Orange |
