Colums to rows

  • Thread starter Thread starter Gary Hull
  • Start date Start date
G

Gary Hull

I have a table the list items across Columns

Example

Column Heading Mill-out Shop Drawings Cut-out

Row Data 80 60 40


Example of what I need


Column Heading Department Time Required

Row Data Mill-out 80
Shop Drawings 60
Cut0out 40




Cross Tab Query doesn’t seem to work


Thank you in advance for your help

Gary Hull
 
No offense, but your problem is causd by the fact that your table isn't
properly normalized. Your desired result is actually how the data should be
stored in the table.

While you're waiting to correct the table, you can use the following Unioni
query to normalize your data. (Note that the query will not be updatable).

SELECT "Mill-out" As Department, [Mill-out] As [Time Required]
FROM MyTable
UNION
SELECT "Shop Drawings", [Shop Drawings]
FROM MyTable
UNION
SELECT "Cut-out", [Cut-out]
FROM MyTable
 
Back
Top