Day: May 8, 2024

I have two output columns from a piece of software, A and B, that give me client’s names in A and country they are based in in B. I’m hoping to create a new column, C, which summarises the country’s continental region (Europe, N. America etc.) for reporting purposes.