data rearrangement

[obermannj]

My dataset has 3 replicates for each of 8 variables arranged one after the other across a row. I need to rearrange them into 3 columns for each row. I have 714 rows to be rearranged, but this number can vary.
There are extra columns at the beginning and end so I will have to exclude those. I can handle transforming the name separately but I don't know how to rearrange the data efficiently. Here is a sample of the starting sheet:

LP MDA Cells_corrected modified.xlsm
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM
1	Name	LP_MB_Cells_01_062	LP_MB_Cells_02_090	LP_MB_Cells_03_064	LP_MB_Cells_04_087	LP_MB_Cells_05_072	LP_MB_Cells_06_058	LP_MB_Cells_07_086	LP_MB_Cells_08_077	LP_MB_Cells_09_078	LP_MB_Cells_10_081	LP_MB_Cells_11_092	LP_MB_Cells_12_091	LP_MB_Cells_13_075	LP_MB_Cells_14_079	LP_MB_Cells_15_069	LP_MB_Cells_16_059	LP_MB_Cells_17_089	LP_MB_Cells_18_084	LP_MB_Cells_19_070	LP_MB_Cells_20_082	LP_MB_Cells_21_083	LP_MB_Cells_22_057	LP_MB_Cells_23_066	LP_MB_Cells_24_088	LP_MB_Cells_25_071	LP_MB_Cells_26_063	LP_MB_Cells_27_056	LP_MB_Cells_28_068	LP_MB_Cells_29_073	LP_MB_Cells_30_055	LP_MB_Cells_31_065	LP_MB_Cells_32_060	LP_MB_Cells_33_074	LP_MB_Cells_34_061	LP_MB_Cells_35_085	LP_MB_Cells_36_076
2	Glucose_0	0.83222	0.90013	0.84573	0.89725	0.89013	0.85873	0.90564	0.88274	0.92397	0.8226	0.90322	0.89229	0.86066	0.90398	0.8658	0.78992	0.83071	0.8163	0.86236	0.86015	0.87463	0.6504	0.86521	0.88133	0.84302	0.7277	0.67184	0.61307	0.83916	0.89483	0.8633	0	0.92921	0.71945	0.88092	0.8235
3	Glucose_1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.00087	0	0	0	0	0	0	0	0	0.00378	0	0	0	0	0	0	0	0
4	Glucose_2	0.08476	0.03351	0.03345	0.00024	0.01707	0.03133	0.04042	0.04078	0.00884	0.02548	0.01166	0.05578	0.03164	0.03191	0.03067	0.00815	0.04059	0.00998	0	0.02327	0.05852	0.09947	0	0.05217	0.05361	0.03325	0.00864	0.04653	0.05742	0	0.06026	0	0	0.05855	0.03765	0
5	Glucose_3	0	0	0	0.01365	0	0	0	0	0	0	0	0	0	0	0.00857	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.00711	0	0	0	0	0
6	Glucose_4	0.0005	0	0	0	0	0.00739	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.0087	0	0	0	0.00247	0	0	0	0	0	0.00312	0	0
7	Glucose_5	0.0072	0	0.00453	0.04553	0	0.00768	0	0	0.01504	0.00455	0	0.00568	0.00864	0.04426	0	0	0.01868	0.04613	0	0.03349	0	0.01139	0.01169	0.0209	0.00515	0	0	0.00215	0.01952	0	0	0	0	0.03614	0	0
8	Glucose_6	0.07532	0.06636	0.11628	0.04333	0.09279	0.09488	0.05394	0.07648	0.05215	0.14737	0.08512	0.04625	0.09906	0.01984	0.09495	0.20193	0.11001	0.12759	0.13677	0.08309	0.06686	0.23874	0.12311	0.0369	0.09821	0.23904	0.31952	0.33199	0.0839	0.10517	0.06933	1	0.07079	0.18274	0.08144	0.1765
9	Glucose-6-phosphate_0	0.2465	0.28551	0.27089	0.20524	0.24822	0.32796	0.17888	0.19694	0.23621	0.16331	0.22596	0.23081	0.22794	0.24681	0.28193	0.19022	0.23354	0.25696	0.40586	0.49831	0.45705	0.31274	0.39423	0.51473	0.58388	0.56501	0.60653	0.42683	0.56218	0.51663	0.52786	0.52589	0.56896	0.40273	0.43834	0.53503
10	Glucose-6-phosphate_1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
11	Glucose-6-phosphate_2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
12	Glucose-6-phosphate_3	0.00562	0.00396	0.00585	0.00225	0.00203	0.00179	0.00399	0.00394	0.0037	0.00253	0	0.00259	0.00302	0.00252	0.00346	0.00193	0.00294	0.00065	0.00295	0.00221	0.00243	0.0007	0.00049	0.00068	0.00056	0.00038	0.00042	0.00062	0.00029	0	0.00031	0.00058	0	0.00092	0.00046	0
13	Glucose-6-phosphate_4	0.00082	0	0.00089	0	0.00063	0.00033	0.00155	0.00068	0.00068	0.00054	0.0004	0.00084	7.9E-05	3E-05	0.00167	0.00077	0.00145	0	0.00099	0.00097	0.00072	0	0.00031	4.6E-05	6.7E-05	0	0	0	0	0.00011	0	0	0	5.4E-05	0	0
14	Glucose-6-phosphate_5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
15	Glucose-6-phosphate_6	0.74705	0.71053	0.72238	0.79252	0.74912	0.66992	0.81558	0.79843	0.75941	0.83362	0.77364	0.76577	0.76895	0.75065	0.71294	0.80708	0.76207	0.7424	0.5902	0.49851	0.5398	0.68656	0.60498	0.48455	0.41549	0.43461	0.39305	0.57255	0.43753	0.48326	0.47183	0.47353	0.43104	0.5963	0.5612	0.46497
16	Fructose-bisphosphate_0	0.02308	0.0242	0.02464	0.01831	0.0188	0.01991	0.01921	0.0222	0.022	0.01648	0.01656	0.01561	0.01892	0.01716	0.01953	0.0143	0.01995	0.01283	0.0198	0.02374	0.02137	0.01446	0.01945	0.01895	0.02044	0.02449	0.01911	0.0156	0.01765	0.01587	0.01941	0.01877	0.02103	0.0134	0.01371	0.0148
17	Fructose-bisphosphate_1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
18	Fructose-bisphosphate_2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
19	Fructose-bisphosphate_3	0.01758	0.01899	0.01745	0.01255	0.0147	0.01449	0.01568	0.01449	0.0174	0.01228	0.0113	0.01177	0.01451	0.01638	0.01775	0.01214	0.01494	0.00966	0.01787	0.02354	0.02099	0.01251	0.01481	0.01458	0.0167	0.01853	0.01766	0.0118	0.0143	0.01331	0.01438	0.01331	0.0148	0.00957	0.01007	0.01068
20	Fructose-bisphosphate_4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.00027	0	0	0	0	0.00024	0	0	0	0	0	0	0	4.8E-05	0	0	0
21	Fructose-bisphosphate_5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
22	Fructose-bisphosphate_6	0.95934	0.95681	0.9579	0.96914	0.9665	0.96561	0.96511	0.96331	0.96059	0.97124	0.97214	0.97262	0.96657	0.96646	0.96272	0.97356	0.96511	0.97751	0.96233	0.95245	0.95764	0.97303	0.96574	0.96647	0.96263	0.95698	0.96322	0.97261	0.96804	0.97082	0.96621	0.96792	0.96412	0.97703	0.97622	0.97452
23	DHAP_0	0.00523	0.00089	0.00555	0.00776	0.00441	0.00942	0.00756	0.00556	0.00766	0.00569	0	0.00565	0.00996	0.00385	0.01366	0.00262	1.1E-05	0.00306	0.00944	0.00975	0.01165	0.00407	0.008	0.00781	0.00849	0.00897	0.0074	0.00517	0.00573	0.00278	0.00659	0	0.00644	0.0025	0.00947	0.00543
24	DHAP_1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	7.7E-05	0	0	0	0	0	0	0	0	0	0	0	0	0
25	DHAP_2	0	0.01313	0	0.04716	0	0	0	0	0	0	0.02754	0.04717	0	0	0	0	0	0	0	0	0.00092	0	0	0	0	0	0	0	0	0	0	0	0	0	0.00256	0
26	DHAP_3	0.99477	0.98597	0.99445	0.94508	0.99559	0.99058	0.99244	0.99444	0.99234	0.99431	0.97246	0.94718	0.99004	0.99615	0.98634	0.99738	0.99999	0.99694	0.99056	0.99025	0.98743	0.99593	0.99193	0.99219	0.99151	0.99103	0.9926	0.99483	0.99427	0.99722	0.99341	1	0.99356	0.9975	0.98797	0.99457
27	2-PG_0	0.01835	0.02081	0.01943	0.01651	0.01429	0.01953	0.0128	0.01148	0.01959	0.01261	0.02147	0.01505	0.01437	0.01656	0.01846	0.01174	0.01345	0.00878	0.01651	0.02289	0.01643	0.00767	0.01474	0.01931	0.02034	0.02331	0.02484	0.02236	0.02231	0.01571	0.02221	0.01706	0.02193	0.01414	0.01105	0.01147
28	2-PG_1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	7.2E-05
Input Data

Cell Formulas
Range	Formula
C2:C28	C2	=CONCAT(A2,"_",B2)

I want to have this:

LP MDA Cells_corrected modified.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1	Glucose_0			Glucose_1			Glucose_2			Glucose_3			Glucose_4			Glucose_5			Glucose_6			Glucose-6-phosphate_0			Glucose-6-phosphate_1			Glucose-6-phosphate_2
2	0.83222135	0.90012801	0.84573202	0	0	0	0.08475714	0.03351306	0.03345173	0	0	0	0.00050057	0	0	0.00720255	0	0.00453498	0.07531838	0.06635893	0.11628127	0.24650474	0.28551	0.27088638	0	0	0	0	0
3	0.89725473	0.89013411	0.85872838	0	0	0	0.00023686	0.01707439	0.03132536	0.01364587	0	0	0	0	0.00738867	0.04553355	0	0.00768069	0.04332899	0.0927915	0.0948769	0.2052358	0.24821741	0.32795806	0	0	0	0	0
4	0.90563669	0.88274466	0.9239694	0	0	0	0.04042167	0.04077784	0.008836	0	0	0	0	0	0	0	0	0.01504487	0.05394164	0.0764775	0.05214974	0.17887747	0.19694296	0.23620584	0	0	0	0	0
5	0.82259689	0.90321763	0.89229232	0	0	0	0.02548199	0.01166196	0.05578164	0	0	0	0	0	0	0.00454787	0	0.00567861	0.14737325	0.0851204	0.04624743	0.16331398	0.22596434	0.23080507	0	0	0	0	0
6	0.86066093	0.90398369	0.86580327	0	0	0	0.03164416	0.03190895	0.0306707	0	0	0.00857278	0	0	0	0.00863531	0.0442641	0	0.0990596	0.01984326	0.09495325	0.22794268	0.2468056	0.28193337	0	0	0	0	0
Sheet2 (3)

Cell Formulas
Range	Formula
A1	A1	='Input Data'!$C$2
D1	D1	='Input Data'!$C$3
G1	G1	='Input Data'!$C$4
J1	J1	='Input Data'!$C$5
M1	M1	='Input Data'!$C$6
P1	P1	='Input Data'!$C$7
S1	S1	='Input Data'!$C$8
V1	V1	='Input Data'!$C$9
Y1	Y1	='Input Data'!$C$10
AB1	AB1	='Input Data'!$C$11
A2	A2	='Input Data'!$D$2
B2	B2	='Input Data'!$E$2
C2	C2	='Input Data'!$F$2
D2	D2	='Input Data'!$D$3
E2	E2	='Input Data'!$E$3
F2	F2	='Input Data'!$F$3
G2	G2	='Input Data'!$D$4
H2	H2	='Input Data'!$E$4
I2	I2	='Input Data'!$F$4
J2	J2	='Input Data'!$D$5
K2	K2	='Input Data'!$E$5
L2	L2	='Input Data'!$F$5
M2	M2	='Input Data'!$D$6
N2	N2	='Input Data'!$E$6
O2	O2	='Input Data'!$F$6
P2	P2	='Input Data'!$D$7
Q2	Q2	='Input Data'!$E$7
R2	R2	='Input Data'!$F$7
S2	S2	='Input Data'!$D$8
T2	T2	='Input Data'!$E$8
U2	U2	='Input Data'!$F$8
V2	V2	='Input Data'!$D$9
W2	W2	='Input Data'!$E$9
X2	X2	='Input Data'!$F$9
Y2	Y2	='Input Data'!$D$10
Z2	Z2	='Input Data'!$E$10
AA2	AA2	='Input Data'!$F$10
AB2	AB2	='Input Data'!$D$11
AC2	AC2	='Input Data'!$E$11
A3	A3	='Input Data'!$G$2
B3	B3	='Input Data'!$H$2
C3	C3	='Input Data'!$I$2
D3	D3	='Input Data'!$G$3
E3	E3	='Input Data'!$H$3
F3	F3	='Input Data'!$I$3
G3	G3	='Input Data'!$G$4
H3	H3	='Input Data'!$H$4
I3	I3	='Input Data'!$I$4
J3	J3	='Input Data'!$G$5
K3	K3	='Input Data'!$H$5
L3	L3	='Input Data'!$I$5
M3	M3	='Input Data'!$G$6
N3	N3	='Input Data'!$H$6
O3	O3	='Input Data'!$I$6
P3	P3	='Input Data'!$G$7
Q3	Q3	='Input Data'!$H$7
R3	R3	='Input Data'!$I$7
S3	S3	='Input Data'!$G$8
T3	T3	='Input Data'!$H$8
U3	U3	='Input Data'!$I$8
V3	V3	='Input Data'!$G$9
W3	W3	='Input Data'!$H$9
X3	X3	='Input Data'!$I$9
Y3	Y3	='Input Data'!$G$10
Z3	Z3	='Input Data'!$H$10
AA3	AA3	='Input Data'!$I$10
AB3	AB3	='Input Data'!$G$11
AC3	AC3	='Input Data'!$H$11
A4	A4	='Input Data'!$J$2
B4	B4	='Input Data'!$K$2
C4	C4	='Input Data'!$L$2
D4	D4	='Input Data'!$J$3
E4	E4	='Input Data'!$K$3
F4	F4	='Input Data'!$L$3
G4	G4	='Input Data'!$J$4
H4	H4	='Input Data'!$K$4
I4	I4	='Input Data'!$L$4
J4	J4	='Input Data'!$J$5
K4	K4	='Input Data'!$K$5
L4	L4	='Input Data'!$L$5
M4	M4	='Input Data'!$J$6
N4	N4	='Input Data'!$K$6
O4	O4	='Input Data'!$L$6
P4	P4	='Input Data'!$J$7
Q4	Q4	='Input Data'!$K$7
R4	R4	='Input Data'!$L$7
S4	S4	='Input Data'!$J$8
T4	T4	='Input Data'!$K$8
U4	U4	='Input Data'!$L$8
V4	V4	='Input Data'!$J$9
W4	W4	='Input Data'!$K$9
X4	X4	='Input Data'!$L$9
Y4	Y4	='Input Data'!$J$10
Z4	Z4	='Input Data'!$K$10
AA4	AA4	='Input Data'!$L$10
AB4	AB4	='Input Data'!$J$11
AC4	AC4	='Input Data'!$K$11
A5	A5	='Input Data'!$M$2
B5	B5	='Input Data'!$N$2
C5	C5	='Input Data'!$O$2
D5	D5	='Input Data'!$M$3
E5	E5	='Input Data'!$N$3
F5	F5	='Input Data'!$O$3
G5	G5	='Input Data'!$M$4
H5	H5	='Input Data'!$N$4
I5	I5	='Input Data'!$O$4
J5	J5	='Input Data'!$M$5
K5	K5	='Input Data'!$N$5
L5	L5	='Input Data'!$O$5
M5	M5	='Input Data'!$M$6
N5	N5	='Input Data'!$N$6
O5	O5	='Input Data'!$O$6
P5	P5	='Input Data'!$M$7
Q5	Q5	='Input Data'!$N$7
R5	R5	='Input Data'!$O$7
S5	S5	='Input Data'!$M$8
T5	T5	='Input Data'!$N$8
U5	U5	='Input Data'!$O$8
V5	V5	='Input Data'!$M$9
W5	W5	='Input Data'!$N$9
X5	X5	='Input Data'!$O$9
Y5	Y5	='Input Data'!$M$10
Z5	Z5	='Input Data'!$N$10
AA5	AA5	='Input Data'!$O$10
AB5	AB5	='Input Data'!$M$11
AC5	AC5	='Input Data'!$N$11
A6	A6	='Input Data'!$P$2
B6	B6	='Input Data'!$Q$2
C6	C6	='Input Data'!$R$2
D6	D6	='Input Data'!$P$3
E6	E6	='Input Data'!$Q$3
F6	F6	='Input Data'!$R$3
G6	G6	='Input Data'!$P$4
H6	H6	='Input Data'!$Q$4
I6	I6	='Input Data'!$R$4
J6	J6	='Input Data'!$P$5
K6	K6	='Input Data'!$Q$5
L6	L6	='Input Data'!$R$5
M6	M6	='Input Data'!$P$6
N6	N6	='Input Data'!$Q$6
O6	O6	='Input Data'!$R$6
P6	P6	='Input Data'!$P$7
Q6	Q6	='Input Data'!$Q$7
R6	R6	='Input Data'!$R$7
S6	S6	='Input Data'!$P$8
T6	T6	='Input Data'!$Q$8
U6	U6	='Input Data'!$R$8
V6	V6	='Input Data'!$P$9
W6	W6	='Input Data'!$Q$9
X6	X6	='Input Data'!$R$9
Y6	Y6	='Input Data'!$P$10
Z6	Z6	='Input Data'!$Q$10
AA6	AA6	='Input Data'!$R$10
AB6	AB6	='Input Data'!$P$11
AC6	AC6	='Input Data'!$Q$11

 

[Fluff]

How about

=VSTACK(TOROW(EXPAND('Input Data'!C2:C28,,3,"")),DROP(REDUCE("",SEQUENCE(ROWS('Input Data'!D2:AM28)),LAMBDA(x,y,HSTACK(x,WRAPROWS(TOCOL(CHOOSEROWS('Input Data'!D2:AM28,y)),3)))),,1))

 

[obermannj]

How about

=VSTACK(TOROW(EXPAND('Input Data'!C2:C28,,3,"")),DROP(REDUCE("",SEQUENCE(ROWS('Input Data'!D2:AM28)),LAMBDA(x,y,HSTACK(x,WRAPROWS(TOCOL(CHOOSEROWS('Input Data'!D2:AM28,y)),3)))),,1))

Works great. Beautiful solution.
Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.