Copy value N times in Excel

Viewed 57348

I have simple list:

  A     B
item1   3
item2   2
item3   4
item4   1

Need to output:

  A
item1
item1
item1
item2
item2
item3
item3
item3
item3
item4
2 Answers
Related