This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.