How to calculate based on consecutive blanks?

[MrMeerkat]

Hello everyone, this request sounds easy but i can’t seem to wrap my head around doing it. Thanks for you help in advance.

Help needed:

Left Table - Input
Right Table - Desired Output

In the desired output:

Streak - based on the consecutive blanks starting from first blank in the respective product column to last blank based on latest date input in the Date column
Last Price - Last filled value
2nd Last price - Second last filled value
3rd Last Price - Third last filled value

 

[kvsrinivasamurthy]

For 365 version.
In J2

=LET(Lr,LOOKUP(1,1/($A:$A<>""),ROW($A:$A)),a,($B$2:INDEX($E:$E,Lr)),rst,Lr-BYCOL(a,LAMBDA(clm,AGGREGATE(14,6,ROW(clm)/(clm<>""),1))),TRANSPOSE(rst))

In K2 copied up to M2

=LET(Lr,LOOKUP(1,1/($A:$A<>""),ROW($A:$A)),a,($B$2:INDEX($E:$E,Lr)),rst,BYCOL(a,LAMBDA(clm,INDEX(clm,AGGREGATE(14,6,(ROW(clm)-1)/(clm<>""),COLUMN(A1))))),TRANSPOSE(IFERROR(rst,"")))