Convert One Column in Two Columns

[ionelz]

Hi,
I have Range B2:B20
I want data from B2:B20 to go in C2:C10 and D2:120
This way :
- first row, third row, fifth row .....in C
- second rows, forth row ....in D
Result of B2:B20

C D
B2 B3
B4 B5
B6 B7

 

[etaf]

as you have 365 - you could use filter and ISEVEN , ISODD
so

Book3
	A	B	C	D	E
1
2		B-2	B-2	B-3
3		B-3	B-4	B-5
4		B-4	B-6	B-7
5		B-5	B-8	B-9
6		B-6	B-10	B-11
7		B-7	B-12	B-13
8		B-8	B-14	B-15
9		B-9	B-16	B-17
10		B-10	B-18	B-19
11		B-11	B-20
12		B-12
13		B-13
14		B-14
15		B-15
16		B-16
17		B-17
18		B-18
19		B-19
20		B-20
21
Sheet1

Cell Formulas
Range	Formula
C2:C11	C2	=FILTER(B2:B20,ISEVEN(ROW(B2:B20)))
D2:D10	D2	=FILTER(B2:B20,ISODD(ROW(B2:B20)))
Dynamic array formulas.