Creating an ARRAY from non-sequential periods

I am trying to consolidate similar impact assumptions year over year - to save having to create large tables of impact numbers going out 20-30 rows/columns. I was hoping I could only add when the changes occurs, please see the example below (with result I need):

12/31/2021: 3%
12/31/2022: 2%
12/31/2025: 1%
12/31/2026: 2%
	
Result:	={3%,2%,2%,2%,1%,2%}

Hope this makes sense. Thanks!

Let's assume that your dates are in Column A and Values are in Column B:

Write this formula in Column C:

Formula:

=LOOKUP(DATE(ROW(INDIRECT(YEAR($A$1)&":"&YEAR($A$4))),{12},{31}),$A$1:$A$4,$B$1:$B$4)

Confirm with Ctrl+Shift+Enter

You will get you array. To see the array select the cell where you have written the formula ---> Go to Formula Bar ---> and Press F9