filter all the data from a range

[Tej92]

Hello all, i'm trying to get excel to get all the data from E2:CC10 to be arranged in column A i've tried using =FILTER(P2:CC10, NOT(ISBLANK(P2:CC10))) and didn't work.
the data in p2:cc10 is also generated by =filter. could that be the problem?
any help is greatly appreciated

 

[Fluff]

Are you trying to get the data into just one column?

 

[Tej92]

yes, all into one in column A from A2

 

[Fluff]

Ok how about

=TOCOL(P2#)

 

[Tej92]

great, it worked!
Is it possible to ignore blanks?

 

[Fluff]

How about

=LET(a,TOCOL(P2#),FILTER(a,a<>""))

 

[Tej92]

works beautifully!! thank you!!!!

 

[Fluff]

You're welcome & thanks for the feedback.