Forum Discussion
Paste CSV data into rows
I have a txt file with zipcodes that is extremely large and exceeds the column limitations in excel. Is there a way to import this data into rows rather than columns in an excel sheet?
Strange, Excel allows up to 16384 columns, are you really exceed this limit?
In general, depends on real data parameters, you may play with TRANSPOSE(). Perhaps Power Query.