ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   extrernal data as a column (https://www.excelbanter.com/excel-discussion-misc-queries/172289-extrernal-data-column.html)

Jugglertwo

extrernal data as a column
 
When I import data from a text file, it comes in as a row of data. Is there a
way to import this data as a column?

Dave Peterson

extrernal data as a column
 
Maybe you could import the data as a row in a new/different worksheet
then copy|paste special|transpose to where you want it to be.

Jugglertwo wrote:

When I import data from a text file, it comes in as a row of data. Is there a
way to import this data as a column?


--

Dave Peterson


All times are GMT +1. The time now is 12:35 PM.

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