Move column that has 2015 and 2016 Sales in two seperate columns

[raycal]

Hi I am looking to separate one column's data into two different columns using the one columns data and the one identifying year. I am trying to use Column A & B to put in Column C & D.

Below is 4 separate columns

Calendar year column A
Sales Column B
2015 Column C
2016 Column D

Calendar Year Sales 2015 2016
2015 11,367
2015 4,104
2015 46
2016 5,747
2015 2,438
2015 12,016
2015 7,626
2016 10,646
2016 16,699

[etaf]

put
=index(B:B, match("2015",A:A,0)
into C
and then put
=index(B:B, match("2016",A:A,0)
into D

now I would click on C and D columns
COPY
Paste >Special Value
so the formulas are nolonger in the columns and you just have the dat

[raycal]

So that sort of worked but I cant get the other cells to adopt the formula.
A B C D
Calendar Year Sales
2015 -2,327 -2326.99 1075.2
2015 -2,327 -2326.99 1075.2
2016 1,075 -2326.99 1075.2
2016 504 -2326.99 1075.2
2016 2,552 -2326.99 1075.2
2016 20,750 -2326.99 1075.2
2016 383 -2326.99 1075.2
2016 450 -2326.99 1075.2
2016 4,582 -2326.99 1075.2
2016 318
2016 2,535
2016 0
2016 1,477
2016 886
2016 1,134
2016 1,521
2016 1,115
2016 924
2016 2,215

[etaf]

we could use an IF and copy down

column C = 2015
Column D = 2016

in C2 put = IF( A2="2015", B2, IF( A2 = "2016", 0, "not 2016/2015" ))
in D2 put = IF( A2="2015", 0, IF( A2 = "2015", B2, "not 2016/2015" ))
and copy down