Equally splitting single column range into multiple columns.

[HighAndWilder]

I'd like to split the data in a single column range into multiple columns starting at a certain cell and with x number of new columns.

I don't want to split the actual text.

I'm sure that I have seen a function to do this.

Thanks

 

[SanjayGMusafir]

Share your sample data and what you want to achieve using XL2BB to understand the scenario and to give you a solution as per your needs.

 

[HighAndWilder]

Share your sample data and what you want to achieve using XL2BB to understand the scenario and to give you a solution as per your needs.

I need to take the use the values from column A and copy them into the two grids as shown. Height of data in column A can vary and number of columns to copy the data
to may vary.

Thanks

Generate list of players for four school teams.xlsm
	A	B	C	D	E	F	G	H	I
1	Data		C1	C2	C3		C1	C2	C3
2	Kug1		Kug1	Kug2	Kug3		Kug1	Kug5	Kug8
3	Kug2		Kug4	Kug5	Kug6		Kug2	Kug6	Kug9
4	Kug3		Kug7	Kug8	Kug9		Kug3	Kug7	Kug10
5	Kug4		Kug10				Kug4
6	Kug5
7	Kug6
8	Kug7
9	Kug8
10	Kug9
11	Kug10
Sheet3

 

[SanjayGMusafir]

Yes there is a function in Excel 365 that let you choose how many columns or rows you want to spill data to. Can't recall immediately as I don't use Excel 365, I just revert. Thanks for your patience

 

[Cubist]

How about this?

Book1
	A	B	C	D	E	F	G	H	I	J
1	Data		C1	C2	C3		C1	C2	C3
2	Kug1		Kug1	Kug2	Kug3		Kug1	Kug5	Kug9
3	Kug2		Kug4	Kug5	Kug6		Kug2	Kug6	Kug10
4	Kug3		Kug7	Kug8	Kug9		Kug3	Kug7
5	Kug4		Kug10				Kug4	Kug8
6	Kug5
7	Kug6
8	Kug7
9	Kug8
10	Kug9
11	Kug10
Sheet12

Cell Formulas
Range	Formula
C2:E5	C2	=WRAPROWS(A2:A11,3,"")
G2:I5	G2	=WRAPCOLS(A2:A11,4,"")
Dynamic array formulas.

 

[HighAndWilder]

How about this?

Book1
	A	B	C	D	E	F	G	H	I	J
1	Data		C1	C2	C3		C1	C2	C3
2	Kug1		Kug1	Kug2	Kug3		Kug1	Kug5	Kug9
3	Kug2		Kug4	Kug5	Kug6		Kug2	Kug6	Kug10
4	Kug3		Kug7	Kug8	Kug9		Kug3	Kug7
5	Kug4		Kug10				Kug4	Kug8
6	Kug5
7	Kug6
8	Kug7
9	Kug8
10	Kug9
11	Kug10
Sheet12

Cell Formulas
Range	Formula
C2:E5	C2	=WRAPROWS(A2:A11,3,"")
G2:I5	G2	=WRAPCOLS(A2:A11,4,"")
Dynamic array formulas.

I knew that there was a suitable function but I could not think of it. Thanks.