im accessing excel through access by creating excelobject and copyd some
querys to its three columns it is like this
columnA -_________ columnC
month/date_______ values ( say item names)
i want an code to use from access which can TRANSPOSE the cell values of
columnC on to columD horizantally basing on columnA month/date values
i mean values of columnB rows aginest columnA month/date vise to be
transposed month vise it looks like this
10/08 _________ pizza
10/08 _________ pepsi
10/08__________ lava
11/08 _________ beef
11/08 _________ chac
12/08 _________ bread
it should transpose to
Month __ 1 2 3 4 5
10/08 ___ pizza ,pepsi,lava
11/08 ___ beef,chac
12/08 ___ bread
Can any one please helpme