Merge two columns in excel

[Virtual_Candy_84]

Hello,

I want to merge two columns - column R and column S. Few data is in column R and few data is in column S. Is there any way or formula to merge the columns?

 

[tigerzen]

Hi, try this:

Book3
	C	D	E
2	3		3
3	4		4
4		5	6
5	6		8
6		7	5
7	8		7
Sheet2

Cell Formulas
Range	Formula
E2:E7	E2	=FILTER(VSTACK(C2:C7,D2:D7),VSTACK(C2:C7,D2:D7)<>0)
Dynamic array formulas.

 

[Virtual_Candy_84]

Hello,

Data is showing like this and I want to make it like this

 

[Georgiboy]

Maybe:

Book1
	A	B	C	D	E
1		1			1
2	2				2
3		4			4
4	4				4
5	6				6
6	8	6			8
7		3			6
8	5				3
9		4			5
10		5			4
11	2				5
12		3			2
13		4			3
14	3				4
15					3
Sheet1

Cell Formulas
Range	Formula
E1:E15	E1	=TOCOL(A1:B14,1)
Dynamic array formulas.