I have a Google Sheet which receives information from a google form.
I would like to collate some of this data in a separate sheet (within the same document). I would like the new sheet to combine data from 4 columns into 2 Columns since the columns contain the same kind of data which we'd like see as a list. I'd also like the blank column to be removed.
The idea being that any time a new entry is made into these fields from the google form- the list would be updated in the second sheet.
I've done an example with pictures below- so columns labelled New song set 1 and New song set 2 would be combined into a list of all new songs- with their corresponding 'first lines' next to them. The blanks would also be removed (as seen in the second picture). The order of the data isn't important.
Do you know how I can do this with formalas?
SECOND SHEET SORTED DATA: