EXCEL FORMULA

Kunal_Mehta 

Using 365 (also required for the FILTER solution):

= LET(
    name, SORT(UNIQUE(Table1[Name])),
    HSTACK(name, MAP(name, Classifyλ))
  )

where the Lambda function, Classifyλ, is defined by

= XLOOKUP(
    100000, 
    IF(Table1[Name] = n, Table1[Date]), 
    Table1[Classification], ,
    -1
  )

To further conceal the actual formula one could wrap the formula within a further Lambda so that the worksheet formula becomes

= CurrentClassificationsλ()

The main criticism of that formula is that it has Table1 hard-wired into the formula rather than showing it as a predecessor using a parameter.   Passing the parameter into the Classifyλ function and providing an alternative to the structured referencing is more challenging.