Hi
I joined multiple sheets in a outer join,
I now would have 5 columns with country names, and would like to compile them into a new column and delete the old ones.
I used concat to join them, but When I delete the old columns the formula stopped working.
How do I permanently move the values?
The dataset has a large number of rows and it's hard to say which column has the values.
Thanks,
Shane
Bookmarks