Pivoting Data for value

[scharny]

I have a worksheet that looks something like this:

Product Fruit Type Size
Product1 Apples Red Delicious L
Product2 Apples Red Delicious M
Product3 Apples Golden S

I am trying to pivot the data to look like this:

Product Classification Detail
Product1 Fruit Apple
Product1 Type Red Delicious
Product1 Size L
Product2 Fruit Apple
Product2 Type Red Delicious
Product2 Size M
Product3 Fruit Apple
Product3 Type Golden
Product3 Size S


Other than a pivot table is there any other way to accomplish this?

 

[Mark W.]

Yes, using this query and the Excel ODBC driver...

SELECT List.Product, 'Fruit' , List.Fruit
FROM `Book3`.List List
UNION
SELECT List.Product, 'Type' , List.Type
FROM `Book3`.List List
UNION
SELECT List.Product, 'Size' , List.Size
FROM `Book3`.List List
ORDER BY List.Product

Book3.xls
	A	B	C	D	E	F	G	H	I	J	K
1	Product	Fruit	Type	Size			Product	Classification	Detail
2	Product1	Apples	RedDelicious	L			Product1	Fruit	Apples
3	Product2	Apples	RedDelicious	M			Product1	Size	L
4	Product3	Apples	Golden	S			Product1	Type	RedDelicious
5							Product2	Fruit	Apples
6							Product2	Size	M
7							Product2	Type	RedDelicious
8							Product3	Fruit	Apples
9							Product3	Size	S
10							Product3	Type	Golden
11
12
13
Sheet1

 

[scharny]

Perfect, thank you very much.