Forum Discussion
Solved
TRANSPOSE without zeroes has 255 character limit
Hi, I am using the TRANSPOSE function with an extra check for blank cells to avoid getting zeroes, i.e.: TRANSPOSE(IF(A1:C1="",A1:C1,"")) However, if one of the cells being transposed has...
The problem is not in TRANSPOSE but in IF. The formula =IF(A1:C1<>"",A1:C1,"") will also return #VALUE! in the third cell.
You could use =TRANSPOSE(A1:C1&"") but that will convert numbers to text.
The problem is not in TRANSPOSE but in IF. The formula =IF(A1:C1<>"",A1:C1,"") will also return #VALUE! in the third cell.
You could use =TRANSPOSE(A1:C1&"") but that will convert numbers to text.
Thank you for your reply. Your suggestion of using TRANSPOSE(A1:C1&"") worked well for me.