Need Formula to Transfer Column Data to another Column; But Omit Cells with no data

Put this formula in B1:

=IF(A1="","",COUNTIF(A$1:A1,"<>"))

and copy it down beyond the data that you have in column A (doesn't really matter how far). Then put this formula in C1:

=IFERROR(INDEX(A:A,MATCH(ROWS($1:1),B:B,0)),"")

then copy that down as far as you need it (i.e. until you get blanks).

Hope this helps.

Pete

Thank you. Unfortunately I attached a bad spreadsheet this is the one I should have attached:

Originally Posted by Pete_UK

Put this formula in B1:

=IF(A1="","",COUNTIF(A$1:A1,"<>"))

and copy it down beyond the data that you have in column A (doesn't really matter how far). Then put this formula in C1:

=IFERROR(INDEX(A:A,MATCH(ROWS($1:1),B:B,0)),"")

then copy that down as far as you need it (i.e. until you get blanks).

Hope this helps.

Pete

Pete - thank you that does help! Because I attached a spreadsheet without formulas, I need to now figure out how to dis-include cells without actual data (right now if there is a formula in the field to copy from, it treats that as data.

Thanks again,
Mike