EXCEL: In the green cells below insert formula(s) that can retrieve the first non-blank and last non-blank values of each respective row without using logical formulas (IF, AND, OR, etc.).

Stock	First non-blank	Last non-blank	Stock Price Day 1	Stock Price Day 2	Stock Price Day 3	Stock Price Day 4	Stock Price Day 5	Stock Price Day 6	Stock Price Day 7
PYT				$56.00	$55.00
LEW			$10.25	$9.00
MRT				$11.00	$15.00	$14.00		$13.50	$13.25
AQD						$15.00	$16.00	$18.00	$17.00
URB			$10.75	$11.00			$12.00
ZOA						$26.35
FNG				$22.44
DET									$14.58
OKL			$11.00	$12.00	$16.00	$15.00	$14.75	$14.50	$14.25
YLE						$12.00		$14.00

In the green cells below insert formula(s) that can retrieve the first non-blank and last non-blank values of each respective row without using logical formulas (IF, AND, OR, etc.). First non- blank Last non- blank Stock Price Day 1 Stock Price Day 4 Stock Price Day 3 $55.00 Stock Price Day 5 Stock Price Day 6 Stock Price Day 7 Stock PYT LEW Stock Price Day 2 $56.00 $9.00 $11.00 $10.25 MRT $15.00 $14.00 $15.00 $13.50 $18.00 $13.25 $17.00 AQD URB $16.00 $12.00 $10.75 $11.00 $26.35 $22.44 ZOA ENG DET OKL YLE $14.58 $14.25 $11.00 $12.00 $16.00 $14.75 $15.00 $12.00 $14.50 $14.00