Hi, Both of these need to be entered as array formulas (Not sure if you have any familiarity there, enter the formula into the cell as below, hit CTRL+SHIFT+ENTER, Grab the handle and drag down or horizontally across other cells as needed)
In Cell D2:
=IFERROR(INDEX($A$2:$A$5,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$5),0)),"")
Drag Down as needed, for your example drag down to D3
In Cell E2:
=IFERROR(INDEX($B$2:$B$5,SMALL(IF($D2=$A$2:$A$5,ROW($A$2:$A$5)- MIN(ROW($A$2:$A$5))+1,""),COLUMN()-4)), "")
Drag Right as needed (To F2 in your example) and then copy E2:F2 to E3:F3
Sample workbook attached as well.
