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!
I've mocked this up below - similar to the other posts on this. If you use a multi-field formula tool to remove the '[Null]' from the blank fields, and a quick formula to pop the remaining bits together, you're off to the races!
If this helps to solve the problem - would you mind marking this as solved, or if there are still questions feel free to reply and we can iterate with you.
I am trying to concatenate 3 columns into 1 new column separated by "/" by the issue is when certain cells are blank the output in the new column looks something like: Phone Number//Home Address. Among the 3 columns, some of the cells will be blank but in this case, I would like the output to show instead as Phone Number/Home Address. Any ideas?