two columns in new one, but one behind another

[anuska]

Hello,
Please I need assistance... I have to columns, A and B, and I need to connect them to column C,
but not as A+B, but as A above B so ->
A
B
Is there a way to do that?
Please help.

Thank you

 

[VoG]

Try in C1

=A1&CHAR(10)&B1

and copy down.

Select the cells in column C, press CTRL + 1, on the Alignment tab tick Wrap Text then click OK.

 

[Sektor]

What do you mean "connect"? Move data in B to the end of A?

 

[anuska]

let me try to explain: I have two columns(along with couple more) but I needthese two to transfer to new sheet as one column, but for instance data in
A B C
1 Aa 1
2 Bb 2
3 Cc 3
Aa
Bb
do not how you will see it... (both data in A and B are dates ). and later I need to sort them out ascending