Inserting two records in output table

Hello,

I have two columns in source table and need to insert two records in a single column in target table.

For example -

Source.ColA > 0 then insert 'XYZ' in target column

Source.ColB >0 then insert 'ABC' in target column

If both Source. Col A and Source.Col B >0 then insert 'XYZ' as one record and 'ABC' as other record.

How could i do that?

Appreciate your help.

Thanks,

Arun