Is there a way to INDEX/SEARCH an array to remove blank columns?

[c.clavin]

Hi guys, is there a way to return an array of all non-blank columns? For example, the array I'm referencing have 5 columns. Column A and C are blank based on a formula I'm using. I'd like the index these 5 columns and only return columns B, D, and E. Is there a way to only display non-blank columns? Thanks!!

 

[StephenCrump]

Something like this?

	A	B	C	D	E	F	G	H	I
1							Filtered
2	Blah	A	Blah	B	C		A	B	C
3		A3		B3	C3		A3	B3	C3
4		A4		B4	C4		A4	B4	C4
5		A5		B5	C5		A5	B5	C5
6		A6		B6	C6		A6	B6	C6
7		A7		B7	C7		A7	B7	C7
8		A8		B8	C8		A8	B8	C8
9		A9		B9	C9		A9	B9	C9
Sheet5

Cell Formulas
Range	Formula
G2:I9	G2	=LET(d,A2:E9,FILTER(d,MMULT(SEQUENCE(,ROWS(d),0),LEN(d)),"Nil"))
A3:E9	A3	=IF(A$2="Blah","",A$2&ROW())
Dynamic array formulas.

 

[c.clavin]

Awesome this works perfectly. I have to figure out this new lingo but thank you so much!

 

[StephenCrump]

Great, I'm glad we could help.