Hello All,

Please i really need urgent help as I have a strict timeline to meet and have been battling with this issue for hours now.

I am trying to copy information from a word doc into excel but whenever I paste instead of it to spread the data across the rows in keeps everything in a single column making it difficult for me to use the data. it has thousands of rows and i can't start manually editing one by one.

What i need is a way to spread this information across the rows so i can select and copy easily.

details of how it looks when imported to excel and how its supposed to be can be found in the attachment.

Book1.xlsx

Thanks in advance. Please save a job.