Is there any way to take the data that is pulled from a filter function and split them into 2 seperate columns.
As an example, I have data in Column A and B. I am filtering the data using a critria in cell D1 to match in B column. The fucntion pulls a total of 10 results. Can this data be displayed in 2 seperate columns of 5 each?
i.e D3:D7 showing A1:A5 and E3:E7 showing A6:A10
function in use
=FILTER(A:A , B:B=D1, "NF")
As an example, I have data in Column A and B. I am filtering the data using a critria in cell D1 to match in B column. The fucntion pulls a total of 10 results. Can this data be displayed in 2 seperate columns of 5 each?
i.e D3:D7 showing A1:A5 and E3:E7 showing A6:A10
function in use
=FILTER(A:A , B:B=D1, "NF")