Forum Discussion
Text aggregating in a single cell
Hello, I realize this is a big question and I'm trying to do several things at once so any help/ ideas/ recommendations are welcome. Anyone who wants to swing big and solve the whole thing for me...
Brent_OKeefe Maybe there is a reason you must have it this way but I just thought I would suggest using a pivot table instead. In a few simple steps I created a pivot table, then created 2 conditional formatting formulas so highlight "Rejected" and "Accepted" names and hid the middle columns:
They are not concatenated into single cells but grouped and give as much or more information.
- Thank you so much for the recommendation. I haven't had much use for pivot tables in the past (crazy, I know) but your example makes me want to consider them. The reason I was looking for all the names to be consolidated into a single cell though was to be able to send out a request for updates from multiple managers using an email campaign through word and outlook.
