# 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? [closed]

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?

edit retag reopen merge delete

### Closed for the following reason question is not relevant or outdated by Alex Kemp close date 2015-11-14 15:09:30.332481

Sort by » oldest newest most voted

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

more