Column value from row

Hi deaconb ,
Thanks to tamerj1 and DataNinja777  for thier methods.
Here's how I solved it
Create column

Trainer = 
VAR _result = 
CALCULATE(
    MAX('Table'[Name]),
    FILTER(
        ALLEXCEPT(
            'Table',
            'Table'[ResponseID]
        ),
        'Table'[Role] = "Trainer"
    )
)
RETURN
IF(
    'Table'[Role] = "Trainee",
    _result,
    BLANK()
)

Create a calculated table

Result = 
SELECTCOLUMNS(
    FILTER('Table','Table'[Trainer] <> BLANK()),
    "ResponseID",'Table'[ResponseID],
    "Trainee",'Table'[Name],
    "Trainer",'Table'[Trainer]
)

Final output

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly