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!