MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Group By Items

  Asked By: Charlie    Date: Nov 29    Category: MS Office    Views: 1508

I would like to group by same items in column.
Say I have,
Product A A A B C C
I would expect output to be
Product Count A 3 B 1 C 2

How do i do that?



1 Answer Found

Answer #1    Answered By: Gilbert Moore     Answered On: Nov 29

Create a pivot table

select the list and heading

Click Data/Pivot table...
accept the first two defaults
choose current worksheet
click where you want the report
drag Products to the row source area
drag products to the data area

Didn't find what you were looking for? Find more on Group By Items Or get search suggestion and latest updates.