+ Reply to Thread
Results 1 to 1 of 1

Combining columns from multiple CSV files to retain monthly data in individual columns

  1. #1
    Registered User
    Join Date
    09-09-2012
    Location
    London, England
    MS-Off Ver
    Excel 365 (Insider Beta)
    Posts
    18

    Combining columns from multiple CSV files to retain monthly data in individual columns

    I have a total of 216 small CSV files that I need to combine in a specific way.

    The consolidate function in the Data tab doesn't seem to do what I want (and I seem to have forgotten what little I knew about PowerQuery and the Data Model).

    Per the attached example (Sheet 1 in attached example), each CSV file relates to a month. I need the months combined into before/after sheets - each month having a column (ideally with the date of acquisition as the column header which is contained within the CSV filename) (see the attached example that I did by hand).

    I know this is a relatively straightforward transformation when importing the data, but I don't know how to do it.

    A bit of help would be much appreciated!


    ``````

    In case it is of any relevance:

    The data are mean temperatures which are calculated using a masked/unmasked process in buffers at 100m intervals extending from 100-2000m from solar power installations and are generated from Landsat images using Google Earth Engine before being saved as individual CSV files for each processed image (see Sheet 1 for exemplar data in the attached Excel Workbook).

    There are three sites, each having before-construction/after-construction data. Site one has 5 paired sets of CSV files (5 x 2 x 12), and Sites 2 & 3 2 sets each (2 x 2 x 12).

    Each CSV file has 40 data.

    Editing the Earth Engine code would take even longer than doing this by hand...
    Attached Files Attached Files

+ 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. Replies: 6
    Last Post: 11-02-2020, 09:40 AM
  2. [SOLVED] Extract data from multiple text files into individual columns
    By JonnyEnglish in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2017, 09:19 AM
  3. Combining data in multiple columns(all columns have same length)into one column
    By nzi0001 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-24-2014, 11:19 AM
  4. Combining multiple rows from 2 columns into sorted columns depending on 1st columns value
    By Dexamphetamine in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-11-2013, 10:00 AM
  5. Help importing multiple text files into individual columns
    By Jev1991 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2013, 11:37 AM
  6. Replies: 1
    Last Post: 04-09-2012, 09:21 AM

Tags for this Thread

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