Combine Multiple Columns (More than 2)

[DKGODFREY]

I need to combine data from multiple columns into one column. On my spreadsheet, a column was created for each church or organization with whom we work. Generally only two of these columns apply to each individual.

On each row are individuals. I would like to combine the columns so that I only have one column for TEAM and one column for DATE.

NOTE: The attached spreadsheet only contains the first 10 rows. I'd like to be able to expand this to an entire spreadsheet that ranges from Column A to Column DZ.
Combine Many Columns.xls

[alansidman]

What would you like the output to look like. I am little dense and not quite sure what you are looking for. Post an example of what the results should like like.

[FlameRetired]

In cell K2 array-enter this formula and fill down to K10

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
Then array-enter this formula in L2 and fill down to L10

Please Login or Register  to view this content.

The workbook is attached and produces these results.

Row\Col	K	L
1	Mission Team	Trip Date
2	Amill	3/24/1994
3	Bfirst	5/4/2001
4	CW1	6/7/2015
5	CH5534	2/3/2001
6	Cumber65	9/3/2004
7	Gow998	8/24/2012
8	IMills334	6/5/1998
9	JF99832	5/4/2006
10	Jones9978	5/7/2006