+ Reply to Thread
Results 1 to 1 of 1

Setup data for Pivot Table

  1. #1
    Registered User
    Join Date

    Setup data for Pivot Table

    Hi All,

    I'm trying to setup my data so that I can create a pivot table. I currently get the data across multiple columns (months of the year). I know that I can transpose the data but not sure how to setup a function that will bring everything over properly and without having to go line by line.

    Attached is a sample of my data. I think I just need to move the 'Raw Data' tab into 'Pivot Data' and should be ok from there.

    Any help would be greatly appreciated.

    Attached Files Attached Files
    Last edited by Paul7; 08-21-2008 at 01:09 PM.

+ 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: 2
    Last Post: 06-23-2008, 09:28 AM
  2. Adding Data to a word table using Excel VBA
    By gskMike in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2008, 08:39 AM
  3. Replies: 2
    Last Post: 02-14-2008, 05:02 PM
  4. Replies: 2
    Last Post: 09-15-2007, 07:31 AM
  5. Date capture in Entry Form to Data Table
    By JIBG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2007, 09:14 PM


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