google search did not help
how to combine all data into one column?
ubuntu 20.04
Formula can be like this:
=OFFSET($A$1;(ROW()-1)/<columns_count>;MOD(ROW()-1;<columns_count>))
For your example it will be
=OFFSET($A$1;(ROW()-1)/3;MOD(ROW()-1;3))
Formula can be like this:
=OFFSET($A$1;(ROW()-1)/<columns_count>;MOD(ROW()-1;<columns_count>))
For your example it will be
=OFFSET($A$1;(ROW()-1)/3;MOD(ROW()-1;3))