Need help in excel new to excel

Occasional Visitor
Sagar   Sagar98765PuneOffice
98765   Sagar 1212345PuneHome
Pune   Sagar 12347879546NagpurOther
Office       
        
Sagar 12       
12345       
Pune       
Home       
        
Sagar 1234      
7879546       
Nagpur       
Other       

 

In column A i have thousands of entries. first is name second is contact number third is location and fourth is place then there is black cell. I need to place entire data as in table as in name below name, number below number, location below location and place below place. I have tried to show how it is required. can anyone please help.

0 Replies