Sagar | | | | Sagar | 98765 | Pune | Office |
98765 | | | | Sagar 12 | 12345 | Pune | Home |
Pune | | | | Sagar 1234 | 7879546 | Nagpur | Other |
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.