For COlumn A (NUmber): put this on cell A15 and copied up to A1

=16-ROWS($A$1:A15)

For Column D (Text): put this on D1 and copied down as necessary

=OFFSET($C$15,-(ROW(A1)-1),0)