Worksheet That Works Like Pivot

A

arjcvg

Hi Guys!

I need your help again.

For example, I have the following data:

Category Description
Beverage Coke
Beverage Pepsi
Beverage Mirinda
Beverage Root Beer
Main Spaghetti
Main Hamburger
Main Salad
Main Fries


What formula should I use to print this in worksheet that looks lik
this?

Column1------Column2
Beverage-----Coke
-----------------Pepsi
-----------------Mirinda
-----------------Root Beer
Main-----------Spaghetti
-----------------Hamburger
-----------------Salad
-----------------Fries


Thanks
 
B

Bernie Deitrick

arjcvg,

No formulas - you should use a pivot table....

HTH,
Bernie
MS Excel MVP
 
Top