I need to combine 30 columns into 1 or 2
 

Ive maxed out 256 columns in my database
I need to combine 30 columns into 1 or 2. Is there a way to do this? I need
to be able to count how many 1,2,3,4,5,6 up to 30 from my database. I have
lots of rows that these numbers are in.
Example:
Barclay 2
Barclay 2
Cass 4
Cass 4
Cass 4
Howard 8
Howard 8
So, I need to know for Barclay that there are 2 twos, Cass 3 fours and so on?
Can I do something like this and how? Any help would be greatly appreciated!

I need to combine 30 columns into 1 or 2
 

Hi,

The easiest way would be do a Pivot Table which will count how many times
each individual entry appears. I presume all of them are arranged in a
column. Try doing a pivot on this column and set the data as count of the
column which contains the info you need to count.

Hope this helps

"Linda" wrote:

Ive maxed out 256 columns in my database
I need to combine 30 columns into 1 or 2. Is there a way to do this? I need
to be able to count how many 1,2,3,4,5,6 up to 30 from my database. I have
lots of rows that these numbers are in.
Example:
Barclay 2
Barclay 2
Cass 4
Cass 4
Cass 4
Howard 8
Howard 8
So, I need to know for Barclay that there are 2 twos, Cass 3 fours and so on?
Can I do something like this and how? Any help would be greatly appreciated!