I am trying to format an excel document to transpose my data from one sheet to another. The data I am trying to transpose is non-numeric thus I want to transpose without the zeroes for blank cells. To do this I generally would use an IF statement to say if the cell is blank return a blank cell otherwise return the value in the cell, but now that I am trying to go across sheets, the equation is not working. Below is the equation I have been trying to use.
{=TRANSPOSE(IF(Sheet1!K:K="","",Sheet1!K:K))}
Any help is welcome!
Thanks
Bookmarks