Counting Occurrences - Where to Start?

[Chad_Cox]

I need help deciding where to start in solving a question.  In figure 1 you can see that we have a list of transactions by Vendor and we want to know how many times each NIGP Family occurs for each Vendor.  We are thinking that image 2 is the end result we desire.  Just a quick and dirty workflow is all we need.  Nothing elaborate.

[Jonathan-Sherman]

Hi @Chad_Cox,

Could you attach some sample data to mock up an example?

Kind regards,

Jonathan

[apathetichell]

So do you want your workflow to perform the count and then pivot - or to pivot an existing column?

you would use summarize to aggregate/group/count and you would use cross tab to pivot wide.

[vlad_kutateladze · Accepted solution]

@Chad_Cox  is this what you are looking for ? 

[binuacs]

@Chad_Cox One way of doing this

[Chad_Cox · Accepted solution]

Thanks for all the suggestions.  I took @vlad_kutateldze suggestion and got the attached results.