Hi, I am trying to extract all the countries that each product is sold in. It should work for all values (including duplicates) and not just the first value. I am not sure why it's returning product name and not the market name. I have presented the problem below and the solution (hand written). The spill should stop at the last value so I don't get lots of zeros. Any help would be greatly appreciated, many thanks. Image uploaded.