Current Field:
| Company | ID |
| Skittles | 1234 |
| Cadbury | 5678 |
Desired Output:
| Company | ID | Company ID |
| Skittles | 1234 | Skittles1234 |
| Cadbury | 5678 | Cadbury5678 |
Use a formula tool to create a new column called Company ID and formula [Company] + [ID]
If [ID] is numeric then [Company] + tostring([ID])
