Adding a Semicolon to the end of Data

[KeelaWilliams]

How do I add a semicolon only to the end of data?

Here is how the data is currently.

This is how I need it to appear on the output.

[geraldo · Accepted solution]

@KeelaWilliams 

if the field is numeric you must create a new string column
using the formula
ToString([Field1]) + ';'
or if it is already string [Field1] + ';'

[alexnajm]

Use a Formula tool and do [Column]+";"

[KeelaWilliams]

What if I have multiple columns that require this same formula? 

[KeelaWilliams]

What if I need this same formula on majority of the columns in my input data?

[geraldo · Accepted solution]

@KeelaWilliams 

example 
more than a column

[KeelaWilliams]

How can I add a semicolon to data that is set to a date and alteryx keep the date format?

[geraldo]

@KeelaWilliams 

an example of in columns and rows
and another in just one column and row

[lbardoe]

You could use the transpose Columns to Rows tool use a formula to add the semi-colon to every value and the use the transpose Rows to Columns tool to put the data back into its original format. You would need to add a Record ID tool before doing the transpose so that it doesnt loose the rows by concatenating the data together.