In E2, copied across to N2 and down:
=IFERROR(INDEX(Data!A:A,AGGREGATE(15,6,ROW(Data!$C$2:$C$30)/(Data!$C$2:$C$30=$A$2),ROWS($1:1))),"")
In O2, copied across to and down:
=IFERROR(INDEX(Data!K:K,AGGREGATE(15,6,ROW(Data!$C$2:$C$30)/(Data!$C$2:$C$30=$A$2),ROWS($1:1)))&"","")
Bookmarks