+ Reply to Thread
Results 1 to 2 of 2

Help importing multiple text files into individual columns

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Leeds, England
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help importing multiple text files into individual columns

    Hi, I'm currently using software which exports velocity data as an individual text file for each time step. I need help finding a way to copy all these files into a single excel file. Each file should be in its own column with each row of the file in its own row. I have tried searching the formus but I mainly came across code which added the next file below the previous one. I have attached a few samples of the data and a copy of how i would like it to look if anybody could point me in the right direction. Test.3fibluvk.000000.txtTest.3fibluvk.000001.txtTest.3fibluvk.000002.txtHow I would like the data to look.xlsx

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Help importing multiple text files into individual columns

    If the files are all in the same folder and have similar names perhaps something like this.

    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1