How do I transpose a table so that rows become columns?

B

bb

What query do I use to convert rows to columns (Table 1 to Table 2)?

Table 1:

PackageID Status City Invoiced
P10 S10 C10 100
P20 S20 C20 200
P30 S30 C30 300
P40 S40 C40 400

Table 2

PackageID P10 P20 P30 P40
Status S10 S20 S30 S30
City C10 C20 C30 C30
Invoiced 100 200 300 400
 
D

Duane Hookom

If you only want the appearance of this data, you can use a multicolumn
report.
Would you really expect to see PackageID as a Value in your new table?
The quick and easy method is to use Excel to Transpose the values.
 
B

bb

I need to produce a multicolumn report. Each row in the source table becomes
a column in the report. Package ID values become the column headers for the
report.

Any ideas?
 
Top