combine rows

[warrenshroyer]

Here is what I am trying to do. is there a function or combination of functions that will help?

excel.jpg

[tigeravatar]

warrenshroyer,

Welcome to the forum!
It looks like you want to concatenate (join strings) based on a condition. Unfortunately, the native excel formula CONCATENATE() does not work with arrays so there is no native function that can perform what you're looking for.

This means that in order to do what you want, you'll need either VBA or an add-in. For this task, I recommend the Morefunc add-in which provides the MCONCAT function which is designed for exactly this task.