var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: From Column Wise data to Row(transactional) Wise data
I have a situation where the revenue is set up in individual columns named for the month and year..
Product Jan 02 Feb 02 Mar 02
XYZ $10 $20 $30
Month Year Product Amt
Jan 2002 XYZ $10
Feb 2002 XYZ $20
Anyone have a code snipit or something set up to do this very easily.
Great your normalizing your data.
First create a table "tblNormalized" with the fields:
ID Autonumber (PK)
then you are going to have to create an append query for each Month field. Below is the SQL for the data from Jan 2002:
INSERT INTO tblNormalized ( Product, Amount, [Date] )
SELECT Table1.Product, Table1.[Feb 02], 1/1/2002 AS [Date]
repeat for each month
You write an alias for each month. I would use a date such as 1/1/2002 for Jan - 02 as you can easily pull out the month and year in a query.
Thanks thats what I Started to do. Was hoping there was an easier way..