Hi Martin,

Thanks. If I do as you said, what difference it will make? It will put a
zero in place of blank cells. I need to get the the very next figure in the
left side, in place of the blanks.

Is it still vague?

Regards,

Jaleel

"MartinW" wrote:

Hi Jaleel,

If I understand you correctly, all you need is to put =A1 in cell E1
then drag it down to E4 then highlight E1 and drag across
to G1 then highlight E2 and drag across to G2 then highlight
E3 and drag to F3

HTH
Martin