Transposing filtered items but skip columns

[FryGirl]

Hello,

This is returning the filtered items from Column B by searching Column A for what's selected in D1, but how can I skip columns? Versus retuning in D2:G2, I'd like the results to be D2, then F2, then H2, the J2, etc.

OSC Groupings.xlsb
	A	B	C	D	E	F	G
1	HDR	Division		SPT
2	SPT	Business Operations		Business Operations	Clinical Operations	Financial Operations	Service Commad Structure
3	SPT	Clinical Operations
4	SPT	Financial Operations
5	SPT	Service Commad Structure
6	DFX	Behavior Health Services
7	DFX	Admin/Locations
8	DFX	Dental Laboratory
9	DFX	Dental Specialties
10	DFX	General Denistry
11	COL	Information Technology
12	COL	Logistics
13	COL	Ambulance
14	COL	Emergency Medicine
15	LXC	General
16	LXC	Trauma
17	LXC	Inpatient Services
18	ETR	Primary Care
19	ETR	Specialty Care
20	ETR	Surgical Services
Sheet1

Cell Formulas
Range	Formula
D2:G2	D2	=TRANSPOSE(FILTER($B$2:$B$20,$A$2:$A$20=D1))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
D1	List	=$Q$2:$Q$6

 

[Fluff]

Do you want to put anything in the "blank" cells?

 

[FryGirl]

No

 

[Fluff]

Ok, how about

=TOROW(EXPAND(FILTER($B$2:$B$20,$A$2:$A$20=D1),,2,""))

 

[FryGirl]

Thank you Fluff. I knew about the TOROW, but didn't know about the expand.

 

[Fluff]

You're welcome & thanks for the feedback.