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

--
Message posted from http://www.ExcelForum.com