Dec 23 2021 11:13 PM
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.