Transpose data usign Transform-Pivot

[carrionk]

Hi,
I Have data stored with the following structure:
Version Product Account Jan Feb Mar Apr May ... Dec
1 Brand1 403050 100 200 150 500 400 100
Id'like to transform it in the following table:
Version Product Account Month Amount
1 Brand1 403050 01 100
1 Brand1 403050 02 200
1 Brand1 403050 03 150
1 Brand1 403050 04 500
..
..
..
Can you address SQL statement to achieve this change?
Regards,
Luis

[Douglas J. Steele]

SELECT Version, Product, Account, 01 As Month, Jan As Amount
FROM MyTable
UNION
SELECT Version, Product, Account, 02 As Month, Feb As Amount
FROM MyTable
UNION
SELECT Version, Product, Account, 03 As Month, Mar As Amount
FROM MyTable
UNION
....
UNION
SELECT Version, Product, Account, 12 As Month, Dec As Amount
FROM MyTable

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<ca******@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi,
I Have data stored with the following structure:
Version Product Account Jan Feb Mar Apr May ... Dec
1 Brand1 403050 100 200 150 500 400 100
Id'like to transform it in the following table:
Version Product Account Month Amount
1 Brand1 403050 01 100
1 Brand1 403050 02 200
1 Brand1 403050 03 150
1 Brand1 403050 04 500
.
.
.
Can you address SQL statement to achieve this change?
Regards,
Luis