'Merge a column of URLs with a column of values
I have two columns in a spreadsheet, "name" and "LinkedIn URL". I'd like to remove the "LinkedIn URL" column and just turn all the names into links to their corresponding url. Is there an easy way to do this without manually copying each link and manually applying the link to the cell?
After creating this new column I would like to remove the original two columns.
Solution 1:[1]
you can hyperlink it and repaste it:
=INDEX(HYPERLINK(B2:B; A2:A))
where A are names and B are urls
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |