I want to group similar items in a column together and need a quick way to do this.
What I have is a list of items (about 2000 items) and there are about 10 different columns for the items respective values ie. item number, item description, supplier, supplier partno ....... .etc. I want to group the items by suppliers. The problem is that cause I have sorted the list by item number the suppliers are not grouped and therefore are not one after the other, what I mean is that row 1 might have supplier1, row 50 might have supplier1 and the ones in between will have other suppliers. What is the quickest way to group by suppliers esp cause its such a big list?
Also if I want the groupings to have a heading on the side where the + and - buttons are, how can I do that? I want the heading to be the supplier's name (which I am grouping by).
Thanks.
What I have is a list of items (about 2000 items) and there are about 10 different columns for the items respective values ie. item number, item description, supplier, supplier partno ....... .etc. I want to group the items by suppliers. The problem is that cause I have sorted the list by item number the suppliers are not grouped and therefore are not one after the other, what I mean is that row 1 might have supplier1, row 50 might have supplier1 and the ones in between will have other suppliers. What is the quickest way to group by suppliers esp cause its such a big list?
Also if I want the groupings to have a heading on the side where the + and - buttons are, how can I do that? I want the heading to be the supplier's name (which I am grouping by).
Thanks.