+ Reply to Thread
Results 1 to 2 of 2

Combining a single column from multiple csv files into one sheet of monthly columns

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

    Unhappy Combining a single column from multiple csv files into one sheet of monthly columns

    Hello,

    I've described my problem here, but have made a bit of progress since then (though largely by slightly informed trial and error).

    I had exported a PQT file but I can't attach it.

    I *think* I've got column headers containing the date, and in Row 2 I have a table of data. When you click on the cell with the word 'Table' in, the data I want is listed on the screen. When I import this into Excel though, it doesn't work.

    Am I on the right track?

    To get the data under a month was using Add Column - Date - Month, then grouping the data by month. This creates an additional column, though, which is probably causing problems later on (when I am trying to merge a single column under each month).

    Help/pointers/suggestions welcome.

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

    Re: Combining a single column from multiple csv files into one sheet of monthly columns

    Happy to provide screenshots/whatever else would help.

    The specific bit I'm stuck on is how to expand the table when loading into Excel (though this is probably also related to the previous steps).
    Last edited by strangecharm; 08-29-2021 at 11:47 AM.

+ 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: 0
    Last Post: 08-28-2021, 11:30 AM
  2. Replies: 1
    Last Post: 03-18-2021, 01:06 PM
  3. Replies: 1
    Last Post: 01-29-2020, 05:19 PM
  4. Combining multiple excel files into a single sheet
    By Santhi28595 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-04-2019, 09:51 AM
  5. Combining multiple columns data into a single column
    By tmor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2016, 07:12 PM
  6. [SOLVED] Combining multiple columns of data into single column
    By dsklein85 in forum Excel General
    Replies: 6
    Last Post: 10-30-2012, 11:18 PM
  7. Export multiple columns to single column text files including special characters
    By mike4uuu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2011, 04:54 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