Worksheet That Works Like Pivot

  • Thread starter Thread starter arjcvg
  • Start date Start date
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
 
arjcvg,

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

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculations in a pivot table data set 2
another lookup! 3
Moving data between worksheets in VBA 2
I'm trying to figure out what would work best for data entry and retreval. 3
help with worksheet design 2
Creating pivot table to Existing worksheet 1
How do I add a list of numbers in a colum that = a repeating word. 2
Pivot Table Calculation 1

Back
Top