Group value in columns with header based on value in another column

Here's one way which delivers it ...
This illustration assumes your data as per your jpg is in cols A and B, in row2 down
Put in C2: =IF(A2="","",IF(COUNTIF(A$2:A2,A2)>1,"",ROW()))
Copy C2 down all the way
Put in D1: =IF(COLUMNS($A:A)>COUNT($C:$C),"",INDEX($A:$A,SMALL($C:$C,COLUMNS($A:A))))
Copy across to E1 (this draws out the unique groups in col A in a horizontal, row-wise manner, all neatly packed to the left)
Put in D2: =IF($A2=D$1,ROW(),"")
Copy across to E2, fill down all the way

Now to draw out the desired end results in adjacent cols to the right ...
Put in G1: =D1, copy across to H1
Put in G2: =IF(ROWS($1:1)>COUNT(D:D),"",INDEX($B:$B,SMALL(D:D,ROWS($1:1))))
Copy across to H2, fill down all the way to extract the desired results, all neatly packed at the top
---------------------------------
Success? Celebrate it, click the little star at the bottom right of my responses