TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.

How to combine multiple columns into one

You will sometimes find yourself with multiple columns of data, but you actually only want this data in one column

A typical example is shown below:

We aren't interested in the date, so we just want all the survey responses in one column.

Simple use the "Split Columns", with the number of columns in each group set to 1. This reformats these three columns into one.

Apply a filter to remove blank entries, and rename the header to give us the data as required: