Resize data to specified number of rows

[Momentman]

I want to transform the data shown below to a number of rows specified by the user. So if the user specifies 19, the data is changed to 10rows and x columns as required to capture the whole data. See below

Excel 2013
	A	B	C	D	E	F	G
1	2348023937941	abakiliki	2348028218959	2348032248256	anuofia	2348029826822	kareem
2	2348024132764	2348020718786	2348021429502	2348031992629	2348031735492	2348022700076	2348022929526
3	2348022094860	2348022120512	2348027471446	2348020795256	2348023120157	2348024462323	2348023313251
4	2348028401550	2348030459523	2348027032705	2348031307087	2348022336347	2348021906417	2348027769701
5	2348029653191	2348028758941	2348023896234	2348020421257	2348022127450	2348024146355	2348030762446
6	2348023303526	2348022652147	2348021643548	2348023930684	2348022518387	2348022179343	2348023728081
7	2348030913626	2348026232982	2348022435480	2348024680695	2348026720576	2348026525298	2348030712868
8	2348030872508	2348026614352	2348025574973	2348030724001	2348020049359	2348022646797	2348030419983
9	2348030358425	2348024550756	2348032079641	2348025887935	2348027013980	2348027716226	2348027219194
10	2348020046493	2348025512781	2348028413378	2348032171294	2348026046707	2348023409104	2348026608798
11	2348027874834	2348020068147	2348021071812	2348030714657	2348022303800	2348020419225	2348023667890
12	2348031414655	2348032252777	2348022050261	2348028147894	2348030184007	2348022398764	2348021268620
13	2348025566802	2348027988962	2348021827860	2348027103483	2348023424479	2348026559766	2348020373561
14	2348022633972	2348024676893			2348022313040	2348031092435	2348026489812
15	2348023452562	2348026705639			2348023917249	2348032257041	2348028747724
Sheet7

1. The new data should be pasted in the next empty column
2. Any data that doesn't start with 234 should not be in the transformed output

 

[Momentman]

The result would look like this

Excel 2013
	K	L	M
1	2348023937941	2348027874834	2348026232982
2	2348024132764	2348031414655	2348026614352
3	2348022094860	2348025566802	2348024550756
4	2348028401550	2348022633972	2348025512781
5	2348029653191	2348023452562	2348020068147
6	2348023303526	2348020718786	2348032252777
7	2348030913626	2348022120512	2348027988962
8	2348030872508	2348030459523
9	2348030358425	2348028758941
10	2348020046493	2348022652147
Sheet7

 

[Momentman]

Let me try simplify

Can I get a VBA code to resize this data

The raw data is in columns A to C and has uneven number of rows but i want to transform to exactly 6 rows and as many columns as are necessary as in the data below

Excel 2013
	A	B	C	D	E	F	G	H	I
1	a	m	v		a	g	m	s	y
2	b	n	w		b	h	n	t	z
3	c	o	x		c	i	o	u
4	d	p	y		d	j	p	v
5	e	q	z		e	k	q	w
6	f	r			f	l	r	x
7	g	s
8	h	t
9	i	u
10	j
11	k
12	l
Sheet1

I know i can easily loop but i have about 1,000,000 data points.

Thanks ffor helping out