teeitup
05-27-2008, 09:10 AM
I currently have a set of data in a traditional budget layout.
With columns:
Primary, Group, Sub-Group, and dates: Jan Feb March Etc. (each in its own column)
Listed under Primary, Group and Sub-Group is information about the type of expense.
Listed under each month is the amount for the given month.
So each row contains many different months of data located in many columns
What I would like to do is convert the data so it can more effectively used in a pivot table.
With Columns:
Primary, Group, Sub-Group, Month, Amount
In this layout instead of having months in many columns it would simply list the month in one common column. So each row would contain only one amount.
I've racked my brain, but can't think of an easy way to make this conversion.
Thanks for the help,
Doug
With columns:
Primary, Group, Sub-Group, and dates: Jan Feb March Etc. (each in its own column)
Listed under Primary, Group and Sub-Group is information about the type of expense.
Listed under each month is the amount for the given month.
So each row contains many different months of data located in many columns
What I would like to do is convert the data so it can more effectively used in a pivot table.
With Columns:
Primary, Group, Sub-Group, Month, Amount
In this layout instead of having months in many columns it would simply list the month in one common column. So each row would contain only one amount.
I've racked my brain, but can't think of an easy way to make this conversion.
Thanks for the help,
Doug