How do I summarize multiple cells from one sheet, into a single cell on another sheet?

Melyssa_Lucas

I am trying to combine several cells of contact cards into one cell in a different sheet.

My source sheet has multiple columns listing project managers from multiple global sites working together on one project. Since they are at different sites/locations, these need to stay separated on the source sheet. In a separate sheet I am creating, I would like all of those cells to be summarized in just one cell to represent the entire project team.

^^So all of these cells that say "DPM or PM" I want to be combined into just one cell on my new sheet.

Hope this makes sense & there is a way to do this??

Thanks!!

Paul Newcome

You would want to do this on the source sheet first in a hidden column then bring over the appropriate cell from the hidden column to the second sheet.