In this Video I explain in detailed about Ms Excel #TRANSPOSE() Function, its a function work as a array function and its help us to switch data Horizontally to Vertically or Vertically to Horizontally. Most of the time we have data in excel worksheet and required to flip that you use Transpose tools that's given in Paste Special Option, but that paste as a value, but this function link data with the cell that you transpose.