Setup data for Pivot Table
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.
Last edited by Paul7; 08-21-2008 at 01:09 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By PriEOn in forum Excel General
Last Post: 06-23-2008, 09:28 AM
By gskMike in forum Excel Programming / VBA / Macros
Last Post: 06-16-2008, 08:39 AM
By phillija in forum Excel General
Last Post: 02-14-2008, 05:02 PM
By Science Boy in forum Excel General
Last Post: 09-15-2007, 07:31 AM
By JIBG in forum Excel Programming / VBA / Macros
Last Post: 09-02-2007, 09:14 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1