Transform Complex Data Directly from Row To Column

While Working With Excel , If the Data is in Simple and i have to Convert Row into Column or column into Row, in which i have to separated and Clean the Data first and then Copy particular data and apply convert text to column and copy again and by using Paste special then Transform But wait🙏! what will Happen If the Data Are in Complex Form and one single box contain more than numbers and Separating the Particular Row Into Column or Vice- Versa. But if u Using this Easy Steps Trick 👇,u can easily Convert data into Column to row 1.Open your Data Excel File Firstly, Make Sure that u have a copy of your Data File then Open your Excel File Which Contain Your Data, in my Case I am Taking a sales report Data of a company in which i have to Convert Particular Column data directly into Row Without Touch any other rows 2. Convert your Data into Table format Now Convert Your Data Into Table Format...