Save Txt file to a one dimensional array

First sub is doing the same as my suggestions. But the transpose can handle around 36k records or less…
Since here are over a million records, you can’t load it in one column at all.