I need to concatenate some cells, but this is tricky and I'm not sure how to do it. Example of data below:
<tbody>
</tbody>
This comes from a pivot, but there are a a few hundred "Companies" and then each company has a various amount of communities under it. What I need is a concatenation of Company and Community, so I would need for example "Account: ABC Company Community 1" for every single community in the list.
Account: ABC Company | ||||||
Sales Director 1 | ||||||
Community 1 | ||||||
Community 2 | ||||||
Community 3 | ||||||
Community 4 | ||||||
<tbody> </tbody> | ||||||
Community 5 | ||||||
Community 6 | ||||||
<tbody>
</tbody>
This comes from a pivot, but there are a a few hundred "Companies" and then each company has a various amount of communities under it. What I need is a concatenation of Company and Community, so I would need for example "Account: ABC Company Community 1" for every single community in the list.