Need a formula, not VBA, for column C? See below.
enter image description here
| A | B | C |
|---|---|---|
| red | 1 | red 1 |
| yellow | 2 | red 2 |
| blue | 3 | red 3 |
| 4 | red 4 | |
| yellow 1 | ||
| yellow 2 | ||
| yellow 3 | ||
| yellow 4 | ||
| blue 1 | ||
| blue 2 | ||
| blue 3 | ||
| blue 4 |
>Solution :
Try: Using TOCOL() & TOROW()
• Formula used in cell C1
=TOCOL(A1:A3&" "&TOROW(B1:B4))