=TRANSPOSE: getting 0es but waste cells wanted
 

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

=TRANSPOSE: getting 0es but waste cells wanted
 

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

=TRANSPOSE: getting 0es but waste cells wanted
 

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

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


"Dave F" wrote:

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