Link to home
Start Free TrialLog in
Avatar of Richard
RichardFlag for United States of America

asked on

Access transform "text" query

How can I use access transform/crosstab query to rotate text as listed below. Don't want to summarize only calculate column header and list the actual value. Or alternatively in MS sql.

Source table...

Id      Material      Document
1      1                a1
2      1                b1
3      1                c1
4      2                a2
5      2                b2
6      2                c2
7      3                a3
8      3                b3
8      4                a4

Results .........

ID      Material      Doc1      Doc2      Doc3
5         1              a1              b1                c1
6         2              a2              b2                b3
7         3              a3              b3      
8         4              a4
Avatar of Richard
Flag of United States of America image


.... correction... .there is not really an id column in the results

 Material      Doc1      Doc2      Doc3
 1              a1              b1                c1
 2              a2              b2                b3
 3              a3              b3      
 4              a4
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard


Perfect... thanks for quick response