Selecting specific columns in a Transpose unique formula

[mrraulipina]

I have a table extract and i'm using a combination of transpose and unique formula to bring in values onto Q2. I'm trying to filter this data so it only brings in column D, E, I L, and O. I keep trying to use the FILTER function but I get errors. I only need the yellow items in my example.

quiz results.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	ID	Start time	Completion time	Email	Name	Total points	Quiz feedback	Grade posted time	Select your Zone:	Points - Select your Zone:	Feedback - Select your Zone:	Select your Business Unit:	Points - Select your Business Unit:	Feedback - Select your Business Unit:	Select your Category/Team:
2	7	####	####	ralph.lauren@altavista.com	Ralph Lauren	24			GLOBAL			GLOBAL			GPOGPE		Email	ralph.lauren@altavista.com	john.doe@altavista.com	donald.trump@altavista.com	jane.goodall@altavista.com	chevy.chase@altavista.com	0
3	8	####	####	john.doe@altavista.com	John Doe	23			NORTH AMERICA			NA			Packaging		Name	Ralph Lauren	John Doe	Donald Trump	Jane Goodall	Chevy Chase	0
4	9	####	####	donald.trump@altavista.com	Donald Trump	15			INTERNATIONAL			WEST			Indirects		Total points	24	23	15	24	25	0
5	10	####	####	jane.goodall@altavista.com	Jane Goodall	24			INTERNATIONAL			EAST			Big		Quiz feedback	0	0	0	0	0	0
6	11	####	####	chevy.chase@altavista.com	Chevy Chase	25			NORTH AMERICA			NA			Logistics		Grade posted time	0	0	0	0	0	0
7																	Select your Zone:	GLOBAL	NORTH AMERICA	INTERNATIONAL	INTERNATIONAL	NORTH AMERICA	0
8																	Points - Select your Zone:	0	0	0	0	0	0
9																	Feedback - Select your Zone:	0	0	0	0	0	0
10																	Select your Business Unit:	GLOBAL	NA	WEST	EAST	NA	0
11																	Points - Select your Business Unit:	0	0	0	0	0	0
12																	Feedback - Select your Business Unit:	0	0	0	0	0	0
13																	Select your Category/Team:	GPOGPE	Packaging	Indirects	Big	Logistics	0
14
15
Sheet3

Cell Formulas
Range	Formula
Q2:W13	Q2	=TRANSPOSE(UNIQUE($D:$O))
Dynamic array formulas.

 

[Alex Blakenburg]

Do you have access to ChooseRows/Columns ?
If you do this might work for you.

=CHOOSEROWS(TRANSPOSE(UNIQUE($D:$O)),1,2,6,9)

 

[mrraulipina]

Do you have access to ChooseRows/Columns ?
If you do this might work for you.

=CHOOSEROWS(TRANSPOSE(UNIQUE($D:$O)),1,2,6,9)

Wow, neat new function, I love it. This worked perfectly, thanks for educating me on the new formula.

 

[Alex Blakenburg]

You're welcome. Glad I could help.