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.
Subscribe this channel to learn excel tricks and tips!
Also, WhatsApp 9013205168 for Excel Online/Offline Classes
Or Buy complete pre-recorded excel course videos - Rs.399
Best Books for Excel -
Excel 2019 All in One : https://amzn.to/3Ek8af9
Excel Formulas and Functions 2020 : https://amzn.to/3CqTB7R (EBook is Free Currently)
Excel Made Easy : https://amzn.to/3Aeujsy
Power Excel with MrExcel : https://amzn.to/2Z1w5jn
Best Laptops for Work and MS Excel -
Under Rs.50000/-
HP 14 Ryzen 5 5500U : https://amzn.to/3nx3igB
Dell Vostro 3405 Ryzen 5 3500U : https://amzn.to/3hxtFiM
ASUS VivoBook Intel Core i5 (10th Gen) : https://amzn.to/3hAgJZg
Under Rs.40000/-
HP 15 (2021) Ryzen 3-3250 : https://amzn.to/3nz0e3K
Dell 14 (2021) i3 (10th Gen) : https://amzn.to/3nxNVVl
ASUS VivoBook 14 (2020) i3 (10th Gen) : https://amzn.to/2YR0gJH