Convert Text to table

Pease see the picture
Anyone have an Idea of how to get from the sample text to this table:

a way might be to use the “text to columns” function in Calc as a middle way - But perhaps there is a smarter way to do it?

Like this:

Select the data that you want to convert.

Find/Replace (Ctrl+H)

In the Find box, type " +" (two spaces before +, don’t type the quotation marks)

In the Replace box, type “\t” (regexp for a tab character)

Tick More options, tick Regular expressions, click Replace all.

All multiple spaces have then be replaced by a tab character.

Select the data again, Table - Convert - Text to table, select tab key as separator character, done.

If this answer helped you, please accept it with :heavy_check_mark: (here on the left). That will help other people with the same question.

Thanks a lot

Wow! I was searching for that a lot! Thank you! It helpt me much! It may added as auto help tip when someone click onto “text to table” or, it must be added as an extra option: Use “all types of spaces” to make table from text. It will be very very convinient!

Thanks. Helped me.

Just to point this is using LO writer , this technique worked from me but I set regular expressions in the find-replace and bulk replaced \s with \t then Select the data again, Table - Convert - Text to table, select tab key as separator character, done.