google sheets – SUM all the Origin of Country

I need a formula that can add all the countries with that is in a column.

Example:
in Sheet ‘Export’ I have below countries of origin:
enter image description here

And in other sheet I need to add all the countries of origin and change the name from RO to Romania or SK to Slovakia, etc…

What I have until now is the formula: =TEXTJOIN(“, “,TRUE, IF(left(Export!Q1,2) = “RO” , “ROMANIA”, IF(left(Export!Q1,2) = “US” , “USA”, IF(left(Export!Q1,2) = “PT” , “PORTUGALIA”, IF(left(Export!Q1,2) = “FR” , “FRANTA”, IF(LEFT(Export!Q1,2) = “SK” , “SLOVACIA”))))))

But is not working. It only add the first country found, not all of them.

Can anyone help?
Thank you