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