I have created a table that is pulling information when entered into a form.
What I would like to do is to summarize the information into maybe a pivot table or a query..not sure what is best at this point.
Let me explain my table:
I have list items that range from P1 to P10 in two seperate columns. How would I do a count so that these two columns get combined together.
Such as: (Keep in mind, these columns would be laid out next to each other, not bellow) Column 1:
I would like the table to take the above information and summarize it as follows: Category:
P3 Number Count: