### Excel 2010 Magic Trick 799: TRANSPOSE IF formula Transpose Data Show Text instead of Blanks/Zeros

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm Rotate Table: 1. Transpose table of data and replace blanks/zeroes with text 2. TRANSPOSE array function 3. IF Function array formula

Length:
03:57