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.