# All columns values in one column

I need some help! :S I have a spreadsheet and three list of items (Column "A", "B" and "C") and I need to put all the values of all the columns in only one column (Column "E"). A picture is following here... I tried everything I could but the true is that I'm not an expert in sheets. So if you can help me to simplify this with a fonction or formula or a miracle :S lol... it would be really appreciated. I really Hope you can help me. You could use in column `E` the `Flatten()` function, like this:

``````=flatten(A2:A30,B2:B30,C2:C30)
``````

EDIT

try this other:

``````=query(flatten(A2:A,B2:B,C2:C),"where Col1 is not null")
``````
• It works... but... my A column have 37 rows, the B 36 and C have 285. So I put the rights rows in the formula and it work but the columns A B and C change constanly... I goes with =FLATTEN(A2:C) but the results have blanks cells between values... do you know how can i make the formula counts only the values of the columns and ignores the blanks ones? Feb 11 at 3:42
• there is a new formula for you :) Feb 11 at 11:09
• THANKS A LOT! it works VERY WELL!!!!! Feb 13 at 3:04