Something like below?
1. Extract unique values from Column A.
In B1: Confirmed as array (CTRL + SHIFT + ENTER)
Formula:
=IFERROR(INDEX(Data!$A$1:$A$30,MATCH(0,COUNTIF($A$1:A1,Data!$A$1:$A$30),0)),"")
Copy across as much as needed (until you see blank).
2. Extract values that match header.
In B2: Confirmed as array (CTRL + SHIFT + ENTER)
Formula:
=IFERROR(INDEX(Data!$B$1:$B$30,SMALL(IF(Data!$A$1:$A$30=B$1,ROW($A$1:$A$30)),ROWS($A$1:A1))),"")
Copy across and down as much as needed (until you see blank across all columns with header value).
See attached.
Bookmarks