Formula to recognize change in Column to Combine with Content in Another Column

[inosent]

I have 2 columns, 1 has a term, the other sub-terms related to the term. Let's call Col A the 'main' category, and Col B the 'sub' category. What I want to do is merge Main with sub so that the Main category and the sub category appear together in the same cell (Col C).

Problem:
<table>
<tr><th><th>Col A<th>Col B</tr>
<tr><td>1<td>Main Category<td>Sub-Category</tr>
<tr><td>2<td>Pets<td></tr>
<tr><td>3<td><td>dog</tr>
<tr><td>4<td><td>cat</tr>
<tr><td>5<td><td>turtle</tr>
<tr><td>6<td>Cars<td></tr>
<tr><td>7<td><td>Honda</tr>
<tr><td>8<td><td>BMW</tr>
</table>
Desired Outcome
<table>
<tr><th><th>Col A<th>Col B<th>Col C</tr>
<tr><td>1<td>Main Category<td>Sub-Category<td>Result</tr>
<tr><td>2<td>Pets<td><td>Pets</tr>
<tr><td>3<td><td>dog<td>Pets - dog</tr>
<tr><td>4<td><td>cat<td>Pets - cat</tr>
<tr><td>5<td><td>turtle<td>Pets - turtle</tr>
<tr><td>6<td>Cars<td><td>Cars</tr>
<tr><td>7<td><td>Honda<td>Cars - Honda</tr>
<tr><td>8<td><td>BMW<td>Cars - BMW</tr>
</table>

I am trying to find a formula in Col C I can fill down to produce that result. I hope the way I formed the question makes sense.

 

[Marcelo Branco]

Try

C2 copied down
=IF(A2<>"",A2,IF(B2<>"",LOOKUP(2,1/(A$2:A2<>""),A$2:A2)&" - "&B2,""))

M.

 

[Aladin Akyurek]

Zie: https://www.mrexcel.com/forum/excel...nally-way-down-when-cell-content-changes.html

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread above.