Filter a list, source list is in 2 columns

[coinbank]

I am running a college football pool and I want to get a list of all of the teams that are playing in the games this year. I want to return the names of the teams in column K & M, in one column (separate schedule) if Column C is "2022". Is there a way to use the filter to pull from both columns?

So on my work computer it won't allow me to install the Mini-Sheet however here is the sheet:

C	D	E	F	G	H	I	J	K	L	M
Year	Playoff/ Champ	Bowl	Location	Date	Time	Network	Fave Rank	Favorite	Dog Rank	Underdog
2022		Bahamas	Nassau, Bahamas	12/16/2022	11:30 AM	ESPN		UAB		Miami (Ohio)
2022		Cure	Orlando, FL	12/16/2022	3:00 PM	ESPN	24	Troy	25	UTSA
2022		Fenway	Boston, MA	12/17/2022	11:00 AM	ESPN		Louisville		Cincinnati
2022		Celebration	Atlanta, GA	12/17/2022	12:00 PM	ABC		Jackson State		NC Central
2022		New Mexico	Albuquerque, NM	12/17/2022	2:15 PM	ESPN		SMU		BYU
2022		Jimmy Kimmel	Los Angeles, CA	12/17/2022	3:30 PM	ABC		Fresno State		Washington State
2022		Lending Tree	Mobile, AL	12/17/2022	5:45 PM	ESPN		Southern Miss		Rice
2022		Las Vegas	Las Vegas, NV	12/17/2022	7:30 PM	ESPN	14	Oregon State		Florida
2022		Frisco	Frisco, TX	12/17/2022	9:15 PM	ESPN		Boise State		North Texas
2022		Myrtle Beach	Conway, SC	12/19/2022	2:30 PM	ESPN		Marshall		Connecticut
2022		Famous Idaho Potato	Boise, ID	12/20/2022	3:30 PM	ESPN		San Jose State		Eastern Michigan
2022		Boca Raton	Boca Raton, FL	12/20/2022	7:30 PM	ESPN		Toledo		Liberty
2022		New Orleans	New Orleans, LA	12/21/2022	9:00 PM	ESPN		South Alabama		Western Kentucky
2022		Armed Forces	Fort Worth, TX	12/22/2022	7:30 PM	ESPN		Baylor		Air Force

 

[fjns]

Hi, see the linked files (with 5 auxiliary columns) for a possible solution for Office2007 and Office2010...

The formulas used in the table:
A2: =INDEX(Source!C:C,ROW())
B2: =INDEX(Source!K:K,ROW())
C2: =INDEX(Source!M:M,ROW())
D2: =IF(A2=2022,1,0)
E2: =IF(A2=2022,SUM(D$2:D2)+1,0)
G1: =MAX(E:E)
I2: =IF(ROW()>G$1,"",INDEX(B:B,MATCH(ROW(),E:E,0))&" & "&INDEX(C:C,MATCH(ROW(),E:E,0)))

CollegeFootball.xlsx
CollegeFootball2.xlsx