0

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.enter image description here

Improve this question

1 Answer 1

Reset to default
0

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")
Improve this answer
3
  • 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?
    – Axel Frey Guarenas
    Feb 11 at 3:42
  • there is a new formula for you :)
    – Daniele
    Feb 11 at 11:09
  • THANKS A LOT! it works VERY WELL!!!!!
    – Axel Frey Guarenas
    Feb 13 at 3:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.