+ Reply to Thread
Results 1 to 2 of 2

Combining data from multiple files into one single file

  1. #1
    Registered User
    Join Date
    11-14-2018
    Location
    New Delhi
    MS-Off Ver
    Office 365 Pro plus
    Posts
    1

    Combining data from multiple files into one single file

    Dear friend

    I have data of daily water level recorded at 10 min interval in different files for each date. There are around 14 files with each file having the name as the date of the recording. In each file, first column in the date of recording, second column is the time of the recording and third column is the water level recorded in meter at that particular date and particular time. The data in each file starts from the third row. First 2 rows are headers for labels for the data. Second row is same for all data but first row contains the date and therefore is different for different files.

    What I want to do is that I want to combine the data from each file such that the entire data is arranged date wise such that data from the file with earlier date should come first and then subsequent rows should contain data from later dates.

    How do I go about doing this action in quick way?

    your sincerely
    Karan Gupta

  2. #2
    Registered User
    Join Date
    11-18-2018
    Location
    sudan
    MS-Off Ver
    2010
    Posts
    4

    Re: Combining data from multiple files into one single file

    Try power query

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract data – Multiple Files – to Single File – in Excel
    By Nostradamus in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-11-2017, 12:00 PM
  2. Consolidate data from multiple excel files into single file
    By hkkk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2013, 03:34 AM
  3. Consolidate data from multiple excel files into single file
    By hkkk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2013, 12:36 AM
  4. [SOLVED] Pull data from the same cell across multiple csv files and place into a single excel file
    By rbmrrbmr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2013, 10:53 AM
  5. Macro for combining similar excel files into single file
    By jsrakesh4u in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2013, 02:06 AM
  6. export data from multiple files into a single file
    By graeme00 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-14-2011, 03:07 PM
  7. Combining multiple XML files into a single spreadsheet
    By marlonJD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2011, 08:14 AM

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