Create duplicate rows based on value in a column

Hello, All. I need a VBA/macro very similar to several I have seen posted here. I have a worksheet with two columns and a few hundred lines. One has titles and the other integers indicating how many times the title needs to be copied to another worksheet or text file.

Existing Worksheet (Input)
TitleA 1
TitleB 6
TitleC 4
TitleD 3

Desired Output (Worksheet or Text File) [The entire row, including the integer could be copied as well, if it is easier.]
TitleA
TitleB
TitleB
TitleB
TitleB
TitleB
TitleB
TitleC
TitleC
TitleC
TitleC
TitleD
TitleD
TitleD

This should be simple, but I am a total newbie with Excel VBA/macros. A sample is attached. Any help will be greatly appreciated.

[Thanks to both for quick and clear replies.]