hello,
Libre Calc - how to split values into rows in one cell?
Sometimes these values are written in the following lines of one cell, and sometimes they are separated by other separators, for example, commas, semicolons or spaces.
The mechanism of Excel is: Power Query
As far as I know, there is no such possibility in Calc. More precisely, it was not until today.
Try this spreadsheet - SplitCells.ods. Of course, running of macros must be allowed.
You can copy the module to your macro library or use this spreadsheet to convert your data (clear the sheet, remove test data, insert your table, click the button and take the result)
thanks a lot, I will check and test your solution 
