One possible solution: replace the blank cells with an apostrophe.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"LevT" wrote:

Hi

I have mixed content with zeroes and spaces in the source range. The
TRANSPOSE function returns zeroes only in place of empty cells. How should I
fix it?

TIA