Merge three columns into one

[koralynah]

Hi there, 

I am trying to merge three columns of data into one. Right now my data looks like the below.. there are four columns under the same header "Type of requisition." I would like to merge all four columns into one column (see 2nd image). I'm not quite sure how I can do this with the transpose tool... Any help is MUCH appreciated!

Before

After

[LoganMeriwether]

A simple solution to this problem (though I don't want to say most effective) would be to use the Formula tool after with the "Replace" function.
For example, if you had a column [key] that contained the content HELLO---WORLD and you only wanted it to say "HELLO-WORLD" you would type
Replace([key], "---", "-") and then run your workflow.
Your example would look like this: Replace([Column Name], "//", "/")

[Teckydoo2]

Thanks this worked for me also. Easy to follow.