'Concatenate cells with different hyperlinks within a single cell
I'm creating a spreadsheet that automatically put the hyperlinks from column D in the values of the column C, because I need to be able to copy the entire C Column with hyperlinks, and paste it elsewhere.

The problem is: If I copy the Column C and paste it anywhere else, it doesn't paste with a line break. It pastes like this:
textofcell1 textofcell2 textofcell3
I need it to be like:
textofcell1
textofcell2
textofcell3
It only works If I copy from Excel to Word, and from Word to anywhere else.
So I wanted to find a solution to concatenate all the cells into a single one, with line break (Alt + Enter) and the hyperlinks, like this:

Because from this single cell I can copy and paste it anywhere else, and it will respect the line break.
Can someone help? Or even if anyone has another solution to copy range C2 to C6 in a way the line break is respected and the hyperlinks follow.
Thank you :)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
