Forum Discussion

ajnarula's avatar
ajnarula
Copper Contributor
Nov 07, 2021

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?

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    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.

Resources