Now Row will shift to columns and column to rows:) Transpose the DATA using PASTE SPECIAL | Excel By Vikal

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. To know more about it watch this video till the end Download Practice F