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