assuming your table is in A15 and you enter the name of interest into say, G1,
then in G2 enter formula:
=IFERROR(INDEX($B$1:$D$1,SMALL(IF(INDEX($B$2:$D$5,MATCH($G$1,$A$2:$A$5,0),0)<>"",COLUMN($B$1:$D$1)-COLUMN($B$1)+1),ROWS($G$1:$G1))),"")
confirmed with CTRL+SHIFT+ENTER not just ENTER, then copied down same number of rows as there are date columns in your table. You may have to format the result as Date to match the table headers.
in H2 enter:
=IF(G2="","",INDEX($B$2:$D$5,MATCH($G$1,$A$2:$A$5,0),MATCH(G2,$B$1:$D$1,0)))
copied down same number of rows.
Bookmarks