Automatically convert data in a column into hyperlinks?
<p>I have a google sheet with a list of names in column A and list of id's in column B.
Is there a way create a single formula, which will convert data in column A into hyperlinks using column A data as title (visible text) and column B data as hyperlink address?</p>

<p>Thank you.</p>