ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need to import data to a coloum not a row (https://www.excelbanter.com/excel-discussion-misc-queries/56824-need-import-data-coloum-not-row.html)

Russ M.

Need to import data to a coloum not a row
 
When importing from a txt file. The data ,which is all seperated by commas,
gets dumped into a row wich is not long enough and cuts off my data. I need
it to dump to a column not a row..Help. Russ

[email protected]

Need to import data to a coloum not a row
 
use paste special and transpose the data

"Russ M." wrote:

When importing from a txt file. The data ,which is all seperated by commas,
gets dumped into a row wich is not long enough and cuts off my data. I need
it to dump to a column not a row..Help. Russ



All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com