Downloaded excel document not formatting with information under headers

[Smitha43]

Hello, I have an excel document that when I am downloaded it has the header section and then underneath the information is running across the screen instead of down the screen under the headers. Have attached an image for example. Is there a way to have the information so it runs down under the headers instead of across the excel file? 

[#2]

How exactly was this data pulled into Excel?

[#3]

It was a document that was downloaded from a website.

[#4]

What is the file extension of that document? https://www.howtogeek.com/205086/beginner-how-to-make-windows-show-file-extensions/

[#5]

It is a .CSV document

[#6]

In that case, try this:
- Open Excel
- Open an empty workbook (control+N)
- Click on the Data tab and click "From text/CSV"
- Select your file and click "Transform Data"

[#7]

Hello, I tried this, and it did not work. The information is still going across the screen instead of down

[#8]

@Smitha43 Are you able to share a sanitized copy of such a CSV file with us by any chance?

See: https://jkp-ads.com/articles/importtext.asp

[#9]

It is sensitive information, so I am not able to share the document.