Hello. I have a rough idea on how to deal with this on excel (Powerquery), however, do we have a way to deal with this on calc?
I need to do some analysis for a school project.
Thanks
Since max number of rows is limited to 2^20 = 1048576 rows. the only way I see is to split your csv file into 4 files files inserted into 4 sheets.