Best option to split a column into 2, 3, 4, 5 or more columns

Question

I have this formula to split a column into two columns:

=ArrayFormula(
IFERROR(HLOOKUP(1,{1;**COLUMN TO DIVIDE**},
(ROW(A:A)+1)*2-TRANSPOSE(sort(ROW(A1:A2)+0,1,0)))))

I would like to know if there is a better way to do this and if there is a way to create one formula that can be used to easily define when I wanted to split one column into two, three, four, five or more columns.

I couldn't create a very concrete way to split into more columns than two. Failures always occur.

Link to spreadsheet: https://docs.google.com/spreadsheets/d/1iUX01lsfrhq7OSMgSg-QZrWL7wMijqpK03uneQZgP3g/edit?usp=sharing

share a copy of your sheet pls – player0 Oct 25 '19 at 16:03 — player0, Oct 25 '19 at 16:03
@player0 Question updated mate. – Digital Farmer Oct 25 '19 at 16:11 — Digital Farmer, Oct 25 '19 at 16:11

score 1 · Accepted Answer · answered Oct 25 '19 at 16:24

1

maybe this will fit your needs:

={FILTER(A2:A, MOD(ROW(A2:A), 2)=0), FILTER(A2:A, NOT(MOD(ROW(A2:A), 2)=0))}

answered Oct 25 '19 at 16:24

player0

124,011
12
67
124

Very simple and intuitive the format executed for 3 or more columns, amazing! – Digital Farmer Oct 25 '19 at 16:41

Best option to split a column into 2, 3, 4, 5 or more columns

1 Answers1