My data has following structu

A09 (code) and B09(time) are headings of a table, its data is filled from
A10 upto B100 or so. A column contains codes which take a value from 1 to 20.
Column B contains data corresponding to the code contained in A. A and B are
filled periodically, and manually.

A01=CODE, A02=TOTAL

Now B02 to U02 contain codes 1 to 20.
B03 to U03 should contain total corresponding to each code, for example
B03 = sumif(A10:A100,"B2",B10:B100)

It is possible that for some codes data does not exist, in that case the
total would be "0".

Is there a function of method which would remove the columns which have zero
total, and leave only those columns which have some data in it, when these
two rows are copied and pasted at a different worksheet?

It is something like, if H03 has total "0", G02 should take place of H02,
and G03 should take place of H03.