Summarizing Text from different Columns

I am trying to figure out a way to combine text data from mulitple columns that probably will have the some same text data. I want to combine these columns into one with a sum of all the text data. Is this possible?

I'm not certain I understand what you want to do, but I think you are question is because the columns have text. You can add the cells A1 + A2 + A3 or you can use the Concatenate(A1,A2,A3).

Sorry for the confusion. What I have is products used for a certain type of service from different days. The products that are used may be totally different day to day but some times some of the products will be the same. I want to be able to take the products from all the days and summarize them in one column showing all product types used without doubleing up on the ones that have been used more then once. I hope that this clears it up a bit.

you need to give details of your data with cell references.