There would be two parts to your query.
- copy the Name as Text and then pasting it in Sheets.
- right click on the Username and select the “Copy link Address”. once this is done, add a hyperlink to the text copied in step 1
There would be two parts to your query.