I need to combine 30 columns into 1 or 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’ve 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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert multiple series into single series 0
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Combining Cells 2
Combine columns into one column 4
Excel Write a formula in excel where 1 = .05, 2 = .75, 3 = .30 etc. 4
Averaging a column that contains text 4
Auto Filter Subtotals 2
counting values in a column 7

Back
Top