Merge multiple columns into one?
Hello! I am trying to put together a form through which my staff can request the use of volunteers. To make this form as easy as possible, I've included a question about which department is requesting. Based on logic, that will take the requester to a dropdown with their most common volunteer requests. In other words, every department has its own drop down menu; to do this, I duplicated my "what do you need volunteers for?" question and changed the drop down menu for each department.
The issues I'm running into is that the sheet represents each question as its own column. I would like to merge all columns of "what do you need volunteers for?" The way I have the logic set up, each row will only have one of the 8 different "what do you need volunteers for?" columns filled. Is there a way to merge two columns into one or have one column take the data contained within another column and copy it? In Google Sheets or Excel I'd use a query function. Does anything like that exist in Smartsheet?