Take Cells from one column and divide up in multiple columns

[robkrouse]

I have one column with 806 rows.

One cell of data in each row.
I want to the split out the rows to different columns with 30 in each column.

Is it possible to do this without having to cut and paste 30 cells at a time?

[alansidman]

have you looked at the built in functionality of Text to Columns found on the Data Tab of the Ribbon?

[robkrouse]

I'm familiar with Text to Columns.
I'm not trying to split the contents of the cells into separate columns.

I'm trying to move the first 30 cells in the column to a separate column.

Then move the next 30 cells to a different column.

Example 1.JPG

[shg]

	a	b	c	d	e	f	g
2	1		1	31	61		c2: =index($a$2:$a$997, rows($c$2:c2) + 30 * columns($c$2:c2) - 30)
3	2		2	32	62
4	3		3	33	63
5	4		4	34	64
6	5		5	35	65
7	6		6	36	66
8	7		7	37	67
9	8		8	38	68
10	9		9	39	69
11	10		10	40	70
12	11		11	41	71
13	12		12	42	72
14	13		13	43	73
15	14		14	44	74
16	15		15	45	75
17	16		16	46	76
18	17		17	47	77

[robkrouse]

AWESOME!!!! I really appreciate it. That just saved me soooooooo much time. ^5

[shg]

You're welcome.