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?
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?