Unstack Data using Excel Formula (No Power Query)

[@josh_excel]

=LAMBDA(r,HSTACK(VSTACK("Row Name",TOCOL(IF(r=r,OFFSET(r,,-1,,1)))),VSTACK("Col Name",TOCOL(IF(r=r,OFFSET(r,-1,,1)))),VSTACK("Data",TOCOL(r))))