Transpose

G

Gargamil

Is there an Access equivalent to the Transpose function in Excel??
Picture a table with say, 6 fields. When displayed as a table each record
represents a month, the first record records the month and the other 5 the
data. If I use the pivot table wizard it will display the results grouped
by the VALUE in one of the columns, what is won't do (at least as far as I
can see in Access) is group by the fieldname.

ie I want
Date A B C D E
1/1/2004 4 5 6 6 7
1/2/2004 6 7 8 9 0

to display as
1/1/2004 1/2/2004
A 4 6
B 5 7
C 6 8
D 6 9
E 7 0

This is easy in Excel since it displays the row headings on the chart.
Access does not. Can any MVP give me a response to this please??

g
 
A

Alex Dybenko

Hi,

no, there is no such Transpose function
if you would have your table in "correct" design as:
Date
Category (a,b,c,d,e)
Vlaue

then you can easy make any of view below

to make this transponse you can first convert it to view i mentioned using
union query and then make what you need using pivot query

--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
 
Top