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, Select your Whole Data by pressing 

( CTRL + A ) on your Keyboard , After that Press ( CTRL + T )    ( for Table Format)
now Your Data Convert into Table .



3. Go to Data Tab Ribbon 

<   DATA   <    Select " From Table / Range" 

4. Excel Will Load to Query

Choose your Whole Column in my Case i am Choosing Column no.2 that is Order no.

After Choosing that , GO to Home Tab

Click on Split column < click on By Delimiter 




5.
when u Choose By Delimiter Option, A window will open 

in which u have to Choose your Data Delimiter, in my case Delimiter is Comma ( , )

Now,

Click on Advanced Option
Now Choose your Convert Option in my Case i Choose Row

then Click on OK



6.
Now After Click on OK,
Your Data Convert into Rows

Click on < Close and Load Option on Left upper Side < Click on Close and Load




   











Now Your Data will Load your New Convert Data On your Excel Workbook Sheet on New Tab, 
 

    












Enjoy 👍 ! 

You May Also Read:

 Turn your Google Sheet Data into Mobile App  click here

Connect Google Sheet Data to workbook excel  click here



Comments

Post a Comment

Popular posts from this blog

Connect Google Sheet Data to workbook Excel

-
Image
In my Every day life. its become a Headache to download on hours basis data from From Google sheet For Further use. Linking Google Sheets to Excel is something now i am using to daily Basis, There are Basic steps which need to do to Link Google Sheet/spreadsheet to your Excel which timely refresh the data and give updated data to you, so lets do it 1.Export/Open Your Google Excel Sheet/Spreadsheet This can be anything you like, but it will be exported to Excel in a table/database format. So I recommend you process your data to a table like structure. 2. CLICK ON : < File Tab (on top left corner of Google Sheet ) < Share < Get link < click on Change to anyone with this link< click on Anyone with this link and < copy that link 3. Open a Note pad or word : (important Step) paste the copied link on note pad or word and Change the format of the link to /export?format=xlsx&id= instead of /edit?usp=sharing for Example: https://docs.google.com/spreadsheets/d/ 1Wz3hQpgQ
Read more

Turn your Google Sheet data into Mobile App

-
Image
Yes ,u hear that Right, You can Easily make a Data Entry Or Data view type Mobile Application which which take Source your data, from  Google Sheet  ....you can make a mobile App /shortcut through your google Sheet/spreadsheet, You can Use Method in your daily Life or in your Office  , if you are the Google Sheet user you must know these fuzzy method and show your impression...   U can Easily update/add/delete/edit your Data by mobile and u can see the changes in your Google Spreadsheet ,or vice versa Google is offering to many Add-on for this , u can choose any one of them , or may see Below step by step to How To turn your Google Spreadsheet in Mobile App So lets do it. 1. You have to Download a Google Add-On which Name As AppSheet or Download it From ( click here ) , it may Ask for Login , So login from your gmail..... Click on Install , it may Take Some Time and added as add-on  2. Open Your Google Sheet/Spreadsheet Go to Your Add-on Ribbon < Click on Add-On , then < Click
Read more

KYA APP TITANIC KI KAHANI JANTE HO?, AGAR NHI TO ABHI DEKHE HINDI MEI

-
Image
बेस्ट चित्र सहित 14 अकादमी पुरस्कारों और 11 के विजेता के लिए चुना गया , टाइटैनिक 1997 में रिलीज होने पर एक दुनिया की सबसे बढ़ी  घटना बन गई। जेम्स कैमरन द्वारा लिखित और बनायीं गयी मूवी , टर्मिनेटर 2 और ट्रू लाइज़ के रूप में इस तरह के हिट के पीछे निर्माता, फिल्म दुखद 1912 डूब एक क्लासिक प्रेम कहानी थी / आर.एम.एस. टाइटैनिक अपने भव्य डिजाइन और दुखद भाग्य के लिए इतिहास के सबसे फेमस जहाजों में से एक के रूप में जाना जाता है। यह एक विशाल 46,000 टन का जहाज था, जिसकी लंबाई 882 फीट और 175 फीट ऊंची थी। "शिप ऑफ़ ड्रीम्स" में एक स्विमिंग पूल, जिम, तुर्की बाद, एक फोटोग्राफी डार्करूम और तीन सिगार रूम शामिल थे। हालांकि, इसकी उचित सुरक्षा सुविधाओं की कमी टाइटैनिक के कयामत की रात में एक महत्वपूर्ण दोष बन जाएगी / आपात स्थिति के लिए निर्धारित लाइफबोट केवल 1,178 लोगों को रखने के लिए सुसज्जित थे, जबकि जहाज स्वयं 2,435 यात्रियों और लगभग 900 चालक दल के सदस्यों को रखने में सक्षम था। 14 अप्रैल, 1912 के अंत के घंटों में, जलयात्रा करने के चार दिन बाद, "अकल्पनीय" टाइटैनिक ने एक बर्फ का टुकड़ा से
Read more