Ask Your Question
0

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]

asked 2013-11-15 07:36:34 +0100

AisIceEyes gravatar image

updated 2015-09-10 10:55:38 +0100

Alex Kemp gravatar image

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 flag offensive 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

1 Answer

Sort by » oldest newest most voted
0

answered 2013-11-15 13:48:37 +0100

m.a.riosv gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-11-15 07:36:34 +0100

Seen: 192 times

Last updated: Nov 15 '13