Hi,
I need to copy a row into a column. The row has cells that contain a whole number or are blank (none can have a value of 0)
I have entrered =TRANSPOSE(ConTtl) as an array formula into ConSmp. ConTtl and ConSmp are named ranges on my worksheet.
The problem is that any blank cell in ConTtl shows as a 0 in ConSmp.
I have tried various ways of incorporating an IF in the TRANSPOSE array formula, but either it can't be done or I am not entering it correctly.
Can the cells in ConSmp be conditionally formatted to traet a value of 0 as blank?
Any help or suggestions greatly appreciated. Thanks.