+ Reply to Thread
Results 1 to 2 of 2

[SOLVED] Pivot Table Automatically Grouping Dates by Year, Quarter, Month etc

  1. #1
    Forum Contributor
    Join Date
    05-26-2004
    Location
    Halifax, UK
    MS-Off Ver
    Office 2016
    Posts
    244

    [SOLVED] Pivot Table Automatically Grouping Dates by Year, Quarter, Month etc

    Hi all,

    I have daily weather data from about a dozen weather stations and am trying to create a pivot table with weather station name as rows and daily max. temperature as columns (one column per day). When I create the pivot table Excel "helpfully" puts in into years and quarters, which I can undo by pressing Ctrl+Z. However that leaves it in Month format and it looks like it just gives me the total sum for all Jan, Feb etc. I just want individual days (this is the format the original data is in) but can't figure out how to get Excel to stop "helping" me by deciding I want my data in some other format!

    TIA
    Last edited by TheRobsterUK; 11-19-2020 at 07:42 AM.

  2. #2
    Forum Contributor
    Join Date
    05-26-2004
    Location
    Halifax, UK
    MS-Off Ver
    Office 2016
    Posts
    244

    Re: Pivot Table Automatically Grouping Dates by Year, Quarter, Month etc

    nm figured it out...right-click the table and select "ungroup" :D

+ 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. Convert list of dates in month / quarter / year format to months only
    By craigsa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2018, 04:33 PM
  2. Replies: 2
    Last Post: 01-08-2018, 03:47 PM
  3. [SOLVED] How to prevent pivot table breaking down dates (Month, Quarter, Year, etc)
    By loccy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-28-2017, 01:44 AM
  4. Replies: 5
    Last Post: 05-03-2017, 02:12 PM
  5. [SOLVED] run time error creating pivot table and group dates by year and month
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2013, 07:25 AM
  6. [SOLVED] PIVOT TABLES: Grouping dates by Fiscal Year, Quarter and Month
    By bimmer5dude in forum Excel General
    Replies: 5
    Last Post: 06-30-2012, 09:13 PM
  7. Trouble with Grouping by Year/Month in Pivot Table
    By mr_bear in forum Excel General
    Replies: 0
    Last Post: 04-13-2010, 03:24 PM

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