Thread: =TRANSPOSE: getting 0es but waste cells wanted
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LevT LevT is offline
external usenet poster
  
Posts: 1
Default =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


Reply With QuoteReply With Quote