Macro To Fill Column?

I need a macro to perform the following:

On column A, from row 2 to 22, I have on each cell, an equal to (=) formula which links the result from another sheet in the same work book.

I need a macro that begining on Column C, everytime the cells in Column A changes from 0 to a number, displays the number on column C and when cell in Column A goes back to 0, Column C retains the number. Next time Column A displays a new number, then Column D is filled, next number Column E and so on.

Example: Lets suppose that cell A2 shows 1234, then cell c2 will show 1234, once cell A2 goes back to 0, cell C2 remains 1234. Then when cell A2 shows a new number 5678, then cell D2 will display the new number 5678 and if A2 goes back to 0 cell D2 will retain the number 5678 and again, once cell A2 displays a new number 1589, then E2 will display 1589, etc, etc. This could happen as many as 20 times (up to column V) before erasing all columns and beginning all over again.