Prefix a column with a word

[nmotiani]

Current Field:

Company	ID
Skittles	1234
Cadbury	5678

Desired Output:

Company	ID	Company ID
Skittles	1234	Skittles1234
Cadbury	5678	Cadbury5678

[Bren_Spill]

Use a formula tool to create a new column called Company ID and formula [Company] + [ID]

If [ID] is numeric then [Company] + tostring([ID])

[Bren_Spill]