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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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?
 
Back
Top