List Total Text

[cob943]

I have a workbook that totals all the worksheets and I need to know how I can list all the different text answers in one box. More specifically, I am running a waste management spreadsheet, and one column has the volume of waste. The next column is the company we use to dispose of it. This may have several different answers depending on our different shops, so on our Totals worksheet, I would like it to list all those places found in that cell throughout all worksheets, possibly separated by a comma or something along those lines. Also, if it could not put in duplicates that would be an added bonus. If you could help me out that would be appreciated. Thanks.

[Mandy11]

Have you tried a pivot table? See Attached. I did 3 for you. Once you learn how to use pivot tables you will love them.

Or you can do a vlookup with an "if" statement. Very complicated to get a few commas.