Paste CSV data into rows

Copper Contributor

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

@ajnarula 

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.