Excel help

Hello,

How do i duplicate rows in excel based on a condition.

e.g.

name count
aa 3
bb 1

i wish to duplicate each name with the number of counts it has.
e.g. for name "aa" , i would like to duplicate it 3 times.
for name "bb", i would like to duplicate it 1 times.
i would not want to manually duplicate as i have 1000 over records.

please share your ideas.