Forum Discussion
ajnarula
Nov 07, 2021Copper Contributor
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
- SergeiBaklanDiamond Contributor
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.