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
the data in p2:cc10 is also generated by =filter. could that be the problem?
any help is greatly appreciated