Hi guys,
Hoping this will be an easy one.

I have a list a countries in column A and a percentage for each country in column B.

I want to use =concatenate(transpose(a#:a#)) the # is used in this example as I have more I need it to do.

The list will be a different length each time, so I guess I can use A:A but I want it only to transpose the countries that have a % of over 0%.

Any ideas?