Merge two columns to one in a special way

Hi, I have a sheet with 2 columns, one with a number that need to be printed and one showing how many copies. In order to print all - several hundreds - in one go I need to merge these two columns to one column like shown in the screendump. Do I need some vba code to do that or any good solotions?