Worksheet That Works Like Pivot
 

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

Worksheet That Works Like Pivot
 

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/