Hello Everyone,

I am not sure how to go about this task and thought I would ask here.

What I have is multiple sheets within a workbook.

to simplify I will break the data down here

Tasksheet has 3 colums with many rows

Column A = ID
Column B = Steps
Column C = Task

Column A has merged Cells ( for rows)
IE
A[1=4] = ID01
Column B1 = 1
Column B2 = 2
Column B3 = 3
Column B4 = 4

Column C1 = Step 1
Column C2 = Step 2
Column C3 = Step 3
Column C4 = Step 4
----------------------------
In another Worksheet called Summary
I have 3 Columns
Column A = Steps
Column B = Actions
Column C = Comments

I have tried to use the following formula =Tasksheet!C2&Tasksheet!C3 to combine the rows into a Single Row, but when I do this it strings the data as a single line
resulting in a row with the following data B1=Step1Step2
What I would prefer is
B1=Step 1 <alt-enter>
Step 2

Secondly I merged the data in columns A1-A4 on the Tasksheet with Alt-Enter and then tried to just copy that cell but it does not preserve the cells formatting. (ie) the alt enter does not copy to the Summary sheet but an Ascii Character like a small box appears between the two lines of data.

Any help with this would be much appreciated.

Have a safe and happy holidays all

RobertCO