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?
Bookmarks