Appending text after extracting non zero text values in a column

[sfshah]

----- A----B----C
1---xyz--xyz--xyz
2---0-----rst---rst
3---0
4---rst
5
6---ABC
7---DEF
[/FONT]
I have text data in column A1:A4. After getting rid of two zero entries using array formulas, I get the non zero texts list in column B consisting of two entries from A1:A4. In column C I want these two entries and I also want to have the contents of A6 and A7 to appear in C5 and C6 automatically. Suppose in A4, it is a 0 instead of "rst", content of B2 would a space, in that case, I want the contents of A6 and A7 to appear in C4 and C5. How do I get it?

Thanks a lot,
Satish

 

[anandvarma]

the example is not clear, can you provide much clear data

 

[sfshah]

ColA
XYZ
0
0
RST
0
UVW
0
0
PQR
SUN

I have text data of 10 rows in a single column which are the results of some formulas, including a few random zeros, say 5 zeros.

After eliminating these 5 zero values cells using the array formulas, I have 5 text data in column B, which would occupy rows 1 to 5 of column B.

Now I want to have in column C these same 5 text values occupying rows 1 to 5, and row 8 and 9 of column C must display the contents of cells A15 and A16 which are fixed values, ABCDEF and GHIJKL and they do not change.

Any increase or decrease on zeros in range A1:A10 should shift the values ABCDEF AND GHIKL down or up in column C accordingly. For example, if there is only one zero in A1:A10, ABCDEF must appear in C12 and GHIKL in C13.

I hope it is clear now.
Thanks,
Satish