I have data with two columns on Sheet A as shown below. I need a formula
in column A of sheet B to display column A of sheet 1 the number of times as
indicated in column B of Sheet 1. Zero values should be excluded. I gave
an example of the output I need below


Sheet A

100 0
101 5
102 3
103 0




===============
Sheet B (Example of output I need) 101 is 5 times and 102 is 3 times. I
need a formula
on this sheet, and can not use VBA.

101
101
101
101
101
102
102
102