Paste CSV data into rows

Occasional Visitor

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?

1 Reply


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.