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
Richard
Flag of United States of America image

ASKER

.... 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
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
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

ASKER

Perfect... thanks for quick response