Help with transferring table data into meaningful list

[AlistairG]

Hi there,

Attached I have a worksheet with a repeated list of countries, and a running total of cases received, as taken from a section of the table next to it. What I would like to be able to do is breakdown the running total into individual cases, and assign a corresponding country to that case, as would appear in column C. For example, from rows 3-12 (1-10 cases) I would like Australia to appear, and then Singapore etc. Would anyone have a formula preferably to do this? If a formlua doesn't work, I would be welcome to Macro ideas.

This is my first time here so any help would be hugely appreciated.

Thanks!
Alistair