Occasional Contributor

I have data in column ''a'' but it's not in order there is on a1, a5, a7, Etc. I want on  column p  it should copy only the cells with data inside I would do =(a1:a1000) but I will get ''0'' where there is no data In column A

1 Reply
best response confirmed by wanalearn (Occasional Contributor)


Put this formula in cell P1:



You will need a relatively new version of Excel for FILTER to work.