How to gather several columns in a single one (excel)

I've tried by using some methods such as query, and pivot table, but looks like there are not way to add a lot of columns into a single one, any suggestion?