Hello everyone,

I have a worksheet with a range of a rows containing cells with numeric values,
empty cells and cells with "0" value.

I want to return in a separate sheet, transposed into two columns, the values
of each row ignoring the cells in a certain range of columns, all empty cells
and all cells with a "0" value.

Into two columns means that data from a certain column will always
be returned in "A" and data from antother column always in "B".

I expect the target columns to grow to max. 1500 rows.

I've been puzzling arround until a big headache decided that this can only be done
by a macro and this is beyond my skills.

working with excel 2010

Anyone care to help?
Thanks.