Current Field:
Desired Output:
Use a formula tool to create a new column called Company ID and formula [Company] + [ID]
If [ID] is numeric then [Company] + tostring([ID])
