Friday, April 17, 2015

yogi_Rearrange Original Table Of Item Category Size Into New Table Of Item Size Category And Quantity

                                           Google Spreadsheet   Post  #1947
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr-14, 2015
question by Brian Gorrasi:!category-topic/docs/spreadsheets/fgZs-JH929A
Count an entry once
Hi All,

I am trying to create a formula for a table but cant figure out how to get it going.  I have a table that has the 3 headers listed below:


Within the category section are 3 possible terms (High, Mid, Low).

Within the size section are 3 possible terms (Large, Medium, Small).

Within the Item section are multiple terms (and constantly changing)

My goal is to create a second table from this original table that gives me a numeric count of the total items based of their category and size.

Original Table
Item      Category     Size
hat            High         L
Hat           high          L
Shoe         High         L
Hat            Mid          M
Shoe         High          S

New Table (from info collected from table 1)

Item           Category      Size        Quantity
Hat               HIgh            L                2
Shoe             HIgh            L                1
Hat               Mid             M                1
Shoe             HIgh            S                1

What formula would I need to write in the Quantity column to give me the proper count per item?