Is there a way for two values from different cells from another sheet can be transposed in two lines in a single cell to another sheet?

English
,
#1

Continuing from this question I’ve asked awhile ago, I’ve been stomped trying to figure out how to make a new line in the same cell, coming from a different sheet but into a new line.

From the question link that have been answered that I’ve posted above, here is more or less what I want to happen:

------------------------------------------------------------------------------------------------
Sheet2.A1 = Sheet1.A1 | Sheet2.B1 = Sheet1.A2  |  Sheet2.C1 = Sheet1.A3 |  Sheet2.D1 = Sheet1.A4 
Sheet2.A1 = Sheet1.B1 | Sheet2.B1 = Sheet1.B2  |  Sheet2.C1 = Sheet1.B3 |  Sheet2.D1 = Sheet1.B4 
------------------------------------------------------------------------------------------------
Sheet2.A2 = Sheet1.A5 | Sheet2.B2 = Sheet1.A6  |  Sheet2.C2 = Sheet1.A7 |  Sheet2.D2 = Sheet1.A8 
Sheet2.A2 = Sheet1.B5 | Sheet2.B2 = Sheet1.B6  |  Sheet2.C2 = Sheet1.B7 |  Sheet2.D2 = Sheet1.B8 
------------------------------------------------------------------------------------------------
Sheet2.A3 = Sheet1.A9 | Sheet2.B3 = Sheet1.A10 | Sheet2.C3 = Sheet1.A11 | Sheet2.D3 = Sheet1.A12 
Sheet2.A3 = Sheet1.B9 | Sheet2.B3 = Sheet1.B10 | Sheet2.C3 = Sheet1.B11 | Sheet2.D3 = Sheet1.B12 
------------------------------------------------------------------------------------------------

Is my above final cells of the 2nd sheet possible?

#2

Use CHAR(10) for join cells with a new line between them.
=B3&CHAR(10)&B4

#3

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.