| 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.
