If data is in A1 or B1 or C1 or D1, put it in E1. (Data, if there is any, can be in only 1 of those 4 cells.)

[SandsB]

....so basically I need the data that's in one of those cells to be in a single column. There's never data in more than 1 of those 4 cells and most of the time the cells are empty. There's about a million rows so I could really use a formula to make things easier.
TIA

 

[Asbestos_Jen]

Would this work?

Book1
	A	B	C	D	E
1	A1				A1
2		B2			B2
3			C3		C3
4				D4	D4
Sheet1

Cell Formulas
Range	Formula
E1:E4	E1	=CONCATENATE(A1,B1,C1,D1)

 

[Trebor76]

Hi SandsB,

Try this:

=IFERROR(XLOOKUP(TRUE,NOT(ISBLANK(A:A)),A:A),"")

Regards,

Robert

 

[Sergius]

This should help

Book1
	A	B	C	D	E
1	A1	B1	C1	D1	A1, B1, C1, D1
Sheet1

Cell Formulas
Range	Formula
E1	E1	=TEXTJOIN(", ",TRUE,A1:D1)

 

[SandsB]

Would this work?

Book1
	A	B	C	D	E
1	A1				A1
2		B2			B2
3			C3		C3
4				D4	D4
Sheet1

Cell Formulas
Range	Formula
E1:E4	E1	=CONCATENATE(A1,B1,C1,D1)

This should help

Book1
	A	B	C	D	E
1	A1	B1	C1	D1	A1, B1, C1, D1
Sheet1

Cell Formulas
Range	Formula
E1	E1	=TEXTJOIN(", ",TRUE,A1:D1)

Would this work?

Book1
	A	B	C	D	E
1	A1				A1
2		B2			B2
3			C3		C3
4				D4	D4
Sheet1

Cell Formulas
Range	Formula
E1:E4	E1	=CONCATENATE(A1,B1,C1,D1)

Like a charm. Thank You!!!!!

 

[Cubist]

Array option:

Book3
	A	B	C	D	E
1	A1				A1
2		B2			B2
3			C3		C3
4				D4	D4
Sheet7

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