All data in one block one line

[Manena]

Good afternoon,
I have converted a PDF into excel and the conversion is bringing all the data in one big piece of information whit only one line.
Please see attachment . There are 2 attachments because I could not delete one of them. One has only the data, the other one has the data and what I want, just in case.
Is it possible to get columns for each piece of information and different lines?
Thanks a lot for your cooperation and help

[TMS]

Text to Columns, delimited by CHAR(10)
Copy the columnar data
Paste Special | Transpose
Text to Columns, delimited by Space(s)

See the attached

Regards, TMS

[Manena]

TMS, thank you very much for taking your time and for resolving my problem.
Every day I am more convinced that there are not impossibles in excel.
Thank you again and have a nice day.

[TMS]

You're welcome. Thanks for the rep.

[Manena]

TMS, sorry but yesterday I got it but today I am lost.
Can you please be so kind and tell me under the text to columns, delimiters what should be on? Where I write the CHAR(10)?
Do I need to write those 2 formulas? =find(Char(10),A1)
I really appreciate you help.
Thanks a lot

[TMS]

Those formulae were just to check that it was, indeed CHAR(10) causing the line breaks. You don't/won't need them.

When you use Text to Columns and choose Delimited, you get a list of "standard" delimiter characters plus the option for "Other". If you tick Other and then click in the empty box, you can hold down the Alt key and type 0010 on the numeric key pad to get CHAR(10).

Regards, TMS

[Manena]

I got it.
Thank you very much, Sir.
Wonderfull

[TMS]

You're welcome.