+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : Import Multiple text rows to one row in Excel

  1. #1
    Registered User
    Join Date
    09-10-2010
    Location
    middletown ny
    MS-Off Ver
    Excel 2007
    Posts
    5

    Import Multiple text rows to one row in Excel

    I have a text file in notepad with 4 rows for each set of data. Is there a way for me to get the data all into 1 row in the text file or all into 1 row in excel.

    Thanks

    P

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Import Multiple text rows to one row in Excel

    It's only 4 rows, open the text file in Excel, then just copy the rows, sounds like 10 seconds work.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    09-10-2010
    Location
    middletown ny
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Import Multiple text rows to one row in Excel

    My problem is I have thousands of 4 row entries

    P

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Import Multiple text rows to one row in Excel

    So your question is really:

    "How can I import 1000s of text files into a single Excel sheet with the 4 rows of data in each file stacked neatly under each other?"


    Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of two of these text files. Also upload a sample Excel sheet showing these two data sets imported and displaying the way you want.

    I have a macro I can tweak for you for this task. Is VBA ok?

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Import Multiple text rows to one row in Excel

    Do you mean you have one text file with thousands of records, but 4 rows per record?
    Remember what the dormouse said
    Feed your head

  6. #6
    Registered User
    Join Date
    09-10-2010
    Location
    middletown ny
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Import Multiple text rows to one row in Excel

    Thanks for clarifying Jerry, you are correct. I have a passing knowledge of VBA let's give it a go.

    Thanks again.

    P

  7. #7
    Registered User
    Join Date
    09-10-2010
    Location
    middletown ny
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Import Multiple text rows to one row in Excel

    Yes that's correct

  8. #8
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Import Multiple text rows to one row in Excel

    What's correct? Please upload 2-3 of these 1000s of text files as requested along with an Excel example of how the samples would look after importing.

    Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

+ 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