I have some cells in column A filled with numbers and some are empty->eg. in A1 is number, A2 number, A3 empty,A4 empty,A5 number,A6 empty etc.
I need some function to collect only not empty cells in column A and write those cells to another column. So in C1 is number from A1,C2->A2,C3->A5. Can anyone help me?
I need some function to collect only not empty cells in column A and write those cells to another column. So in C1 is number from A1,C2->A2,C3->A5. Can anyone help me?