I want to import a text file to Calc in the form of a table

Hi there
I need to import a text file that is written as a single giant column with 100 or more lines

But I need to import in a way that it becomes a 10x10 table

I wanted to try something like “every 10 lines, skip to the noext column”

Is there anything such as that?

All depends on the details formatting of the text file.

I would try to do:

Make a backup file!

Right click on the text file
Select Open with > Calc
Look at the possible settings. In this window one sees already how the file spreadsheet will look like.

Worst case:
Get all in 1 column and move in units of 10 lines into the next column. Time needed: 10 x 20 sec