arjcvg,
No formulas - you should use a pivot table....
HTH,
Bernie
MS Excel MVP
"arjcvg " wrote in message
...
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 like
this?
Column1------Column2
Beverage-----Coke
-----------------Pepsi
-----------------Mirinda
-----------------Root Beer
Main-----------Spaghetti
-----------------Hamburger
-----------------Salad
-----------------Fries
Thanks!
---
Message posted from http://www.ExcelForum.com/