Google Sheets: How do I combine a column of URLs and a column of text into one?

Question

How do I combine two separate columns of Titles and Webpages into one?

The list is very long so I can't do it one by one. Thanks

Answer 1

I think what you want is:

=hyperlink(B1,A1)

This preserves the link as in B1 but gives it the friendly name as in A1.