Un-binning count data

[DougR]

I have two columns. Column A contains a bin range.

e.g

10
10.5
11
11.5

Column B contains counts

e.g

2
4
1
3

I need a formula that lists every value individually in column C.

e.g.

10
10
10.5
10.5
10.5
10.5
11
11.5
11.5
11.5

Any help would be greatly appreciated.

Thanks.

 

[Mark W.]

Drag down the yellow highlighted formulas until the last set contains no value in column B greater than 1. Paste values to another location, AutoFilter for rows with a B value less than 1, and delete those rows.

Book1
	A	B	C	D
1
2	10	2
3	10.5	4
4	11	1
5	11.5	3
6	10	1
7	10.5	3
8	11	0
9	11.5	2
10	10	0
11	10.5	2
12	11	-1
13	11.5	1
14	10	-1
15	10.5	1
16	11	-2
17	11.5	0
18
19
20	10	2		<-- Filtered (and sorted) range where values<1 are deleted
21	10	1
22	10.5	4
23	10.5	3
24	10.5	2
25	10.5	1
26	11	1
27	11.5	3
28	11.5	2
29	11.5	1
Sheet1