Hello all,
I hope I can clearly explain my question. I use excel 2013. I have the same text "packaging" appear various times in the same column and also in 5 different columns various time. How can I combine the same text from all 5 columns into 1 column and get the total. For ex. On column A I have "packaging" appear 10 times throughout the rows, and in column B I have "packaging" appear 15 times in DIFFERENT rows, and so on so forth. Is there a way for a pivot table combine the rows with the same text and provide the count?