=TRANSPOSE: getting 0es but waste cells wanted

[LevT]

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

 

[Guest]

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

Dave

 

[Guest]

Here's an alternative method: http://www.mrexcel.com/archive/Edit/3118.html

Dave